# Ansible synchronize database sql

**URL:** <https://forum.ansible.com/t/ansible-synchronize-database-sql/29955>\
**Category:** Ansible Project\
**Created:** [March 22, 2019, 3:48pm UTC](https://forum.ansible.com/t/ansible-synchronize-database-sql/29955 "2019-03-22T15:48:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ryad9200000](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\
**Post date:** [March 22, 2019, 3:48pm UTC](https://forum.ansible.com/t/ansible-synchronize-database-sql/29955/1 "2019-03-22T15:48:13Z")

</div>

Hi all,

**"** Data synchronization can be resumed by right-clicking on the database and choosing “Resume data movement …”. **"**

 ![Resume_data_movement_of_sql_server.png](https://us1.discourse-cdn.com/ansible/original/2X/7/7670fd460252bd31f7ab745fdbc17ace27d93071.png)

I want know if in ansible its possible to realize the same thing as on the image.

That is to resynchronize a database?

I see module database of ansible but without success.

Someone have an idea please ?

Thanks community ansible !! 😉

Regards,

---

<div class="post-metadata">

**Author:** ![ryad9200000](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\
**Post date:** [March 22, 2019, 4:33pm UTC](https://forum.ansible.com/t/ansible-synchronize-database-sql/29955/2 "2019-03-22T16:33:31Z")

</div>

New question,

Can i execute line command SQL in ansible ?

How can i do it please ??

Thanks

Regards,

---

<div class="post-metadata">

**Author:** ![Keif\_Gwinn](https://avatars.discourse-cdn.com/v4/letter/k/e0b2c6/32.png) [@Keif\_Gwinn](https://forum.ansible.com/u/Keif_Gwinn)\
**Post date:** [March 22, 2019, 5:17pm UTC](https://forum.ansible.com/t/ansible-synchronize-database-sql/29955/3 "2019-03-22T17:17:07Z")

</div>

Not really an ansible question, but you can always execute powershell commands a windows host with access to the database server and this command

[https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/resume-an-availability-database-sql-server?view=sql-server-2017#PowerShellProcedure](https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/resume-an-availability-database-sql-server?view=sql-server-2017#PowerShellProcedure)

---

<div class="post-metadata">

**Author:** ![ryad9200000](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\
**Post date:** [March 25, 2019, 8:30am UTC](https://forum.ansible.com/t/ansible-synchronize-database-sql/29955/4 "2019-03-25T08:30:25Z")

</div>

Hi Keif Gwinn,

Thanks for answer, i will go try command SQL with powershell command in ansible 😉

Regards,