How to execute a SQL Script ( MS SQL 2014 SP2 ) by Ansible

[ameya agashe]

Hello Guys,

I have copied a script on MS SQL server on c:\temp\always-on.sql

I'm wondering how to have it executed by Ansible, win_shell module? or is there any specialized module for MSSQL for Ansible?

Kindly assist

Thanks

Ameya Agashe 

[Dick Visser]

There is no specific mssql query module part of ansible itself, but a 3rd party module does exist for this purpose: 

https://github.com/melmorabity/ansible-mssql-query 

If you can, report on its usability.

Dick 

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To post to this group, send email to ansible...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAG9tf-9fwrSLU6RWeRbzV5fwiHJRL%3D1P9PNnkVvLEdBP72D2_g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--

Sent from a mobile device - please excuse the brevity, spelling and punctuation.

[ameya agashe]

Sounds good, I shall certainly try and provide feedback here.

Many thanks

Ameya Agashe

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAL8fbwOQD_VELsvJN%2BcvmQUQnO%3D8u5PqrSagUFFg%2BuchpXko8Q%40mail.gmail.com.