# Run script sql on ansible

**URL:** <https://forum.ansible.com/t/run-script-sql-on-ansible/30312>\
**Category:** Ansible Project\
**Created:** [May 13, 2019, 8:05am UTC](https://forum.ansible.com/t/run-script-sql-on-ansible/30312 "2019-05-13T08:05:05Z")\
**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:** [May 13, 2019, 8:05am UTC](https://forum.ansible.com/t/run-script-sql-on-ansible/30312/1 "2019-05-13T08:05:05Z")

</div>

Hey all,

I have a database SQL Server and i must run some script **.sql** on this database with ansible.

I would like know if possible to run script .sql with ansible on database SQL Server ?

Thanks for your help !! 🙂

Thank you guy !! 😉

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:** [May 13, 2019, 3:16pm UTC](https://forum.ansible.com/t/run-script-sql-on-ansible/30312/2 "2019-05-13T15:16:44Z")

</div>

Hey,

Someone can help me please !! 🙂

thanks community ansible !! ^^

Regards,

---

<div class="post-metadata">

**Author:** ![Igor\_Turovsky](https://avatars.discourse-cdn.com/v4/letter/i/cdc98d/32.png) [@Igor\_Turovsky](https://forum.ansible.com/u/Igor_Turovsky)\
**Post date:** [May 15, 2019, 10:27pm UTC](https://forum.ansible.com/t/run-script-sql-on-ansible/30312/3 "2019-05-15T22:27:59Z")

</div>

Generally, you can do with Ansible everything you can do with CLI on your platform.  
If you mean MS SQL server on Windows, you can:

1. use win\_copy to copy script.sql from Ansible host to Windows machine
2. use win\_shell: Invoke-SQLCmd -InputFile script.sql.  
Thank you,

- Igor

пн, 13 мая 2019 г. в 18:16, Ryad karkar \<[ryad9200000@gmail.com](mailto:ryad9200000@gmail.com)\>:

---

<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:** [May 20, 2019, 7:35am UTC](https://forum.ansible.com/t/run-script-sql-on-ansible/30312/4 "2019-05-20T07:35:19Z")

</div>

Hey Igor,

Thanks very much for your answer !! 😉

Thank you very much for your help !! ^^

Regards,