Ansible synchronize database sql

Archives Ansible Project
1

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
Resume_data_movement_of_sql_server.png701×493 50.4 KB

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 !! :wink:

Regards,

2

New question,

Can i execute line command SQL in ansible ?

How can i do it please ??

Thanks

Regards,

3

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

4

Hi Keif Gwinn,

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

Regards,