mssql_db – Add or remove MSSQL databases from a remote host¶
Requirements¶
The below requirements are needed on the host that executes this module.
- python >= 2.7
- pymssql
Parameters¶
Notes¶
Note
- Requires the pymssql Python package on the remote host. For Ubuntu, this is as easy as pip install pymssql (See pip.)
Examples¶
# Create a new database with name 'jackdata'
- mssql_db:
name: jackdata
state: present
# Copy database dump file to remote host and restore it to database 'my_db'
- copy:
src: dump.sql
dest: /tmp
- mssql_db:
name: my_db
state: import
target: /tmp/dump.sql
Status¶
- This module is not guaranteed to have a backwards compatible interface. [preview]
- This module is maintained by the Ansible Community. [community]
Authors¶
- Vedit Firat Arig (@vedit)
Hint
If you notice any issues in this documentation, you can edit this document to improve it.