# Ansible and SQL Server ?

**URL:** <https://forum.ansible.com/t/ansible-and-sql-server/29991>\
**Category:** Ansible Project\
**Created:** [March 26, 2019, 1:00pm UTC](https://forum.ansible.com/t/ansible-and-sql-server/29991 "2019-03-26T13:00:44Z")\
**Posts on this page:** 3\
**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 26, 2019, 1:00pm UTC](https://forum.ansible.com/t/ansible-and-sql-server/29991/1 "2019-03-26T13:00:44Z")

</div>

Hi all,

I want know if Ansible can execut commands SQL for Microsoft SQL Server ?

I think that possible with command powershell but what is syntax ansible ?

for exemple, i want create table on my SQL Server (CREATE DATABASE ma\_base) with Ansible…

What is a procedure ? I know there is win\_shell and then … ?

Thank you very much community ansible !!

Regards,

---

<div class="post-metadata">

**Author:** ![aidewuado](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@aidewuado](https://forum.ansible.com/u/aidewuado)\
**Post date:** [March 26, 2019, 1:09pm UTC](https://forum.ansible.com/t/ansible-and-sql-server/29991/2 "2019-03-26T13:09:19Z")

</div>

im used win\_command whit SQLCMD

Ejm:

- name: Copia Script DBA  
win\_copy:  
src: script\_dbaGenerico.sql  
dest: “{{ servers\_setup\_dir }}\script\_dbaGenerico.sql”

- name: exec createDBA  
win\_command: “sqlcmd -U sa -P {{ mssql\_sa\_pwd }} -S {{ ansible\_hostname }} -i script\_dbaGenerico.sql”  
args:  
chdir: “{{ servers\_setup\_dir }}”

- name: Borra archivos instaladores  
win\_file:  
path: “{{ item }}”  
state: absent  
with\_items:

- “{{ servers\_setup\_dir }}\ConfigurationFile.ini”

- “{{ servers\_setup\_dir }}\script\_dbaGenerico.sql”

---

<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 26, 2019, 1:44pm UTC](https://forum.ansible.com/t/ansible-and-sql-server/29991/3 "2019-03-26T13:44:55Z")

</div>

Hi andres,

Okey !! Thank you very much for your answer !!

I will try this isue quickly !! 😉

Thanks,

Regards