community.general.mssql_db – Add or remove MSSQL databases from a remote host.

Note

This plugin is part of the community.general collection (version 2.0.1).

To install it use: ansible-galaxy collection install community.general.

To use it in a playbook, specify: community.general.mssql_db.

Synopsis
Requirements
Parameters
Notes
Examples

Synopsis

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

Parameter	Choices/Defaults	Comments
autocommit boolean	no ← yes	Automatically commit the change only if the import succeed. Sometimes it is necessary to use autocommit=true, since some content can't be changed within a transaction.
login_host string / required		Host running the database
login_password string		The password used to authenticate with
login_port string	Default: "1433"	Port of the MSSQL server. Requires login_host be defined as other than localhost if login_port is used
login_user string		The username used to authenticate with
name string / required		name of the database to add or remove aliases: db
state string	present ← absent import	The database state
target string		Location, on the remote host, of the dump file to read from or write to. Uncompressed SQL files (`.sql`) files are supported.

Notes

Note

Requires the pymssql Python package on the remote host. For Ubuntu, this is as easy as pip install pymssql (See ansible.builtin.pip.)

Examples

- name: Create a new database with name 'jackdata'
  community.general.mssql_db:
    name: jackdata
    state: present

# Copy database dump file to remote host and restore it to database 'my_db'
- name: Copy database dump file to remote host
  ansible.builtin.copy:
    src: dump.sql
    dest: /tmp

- name: Restore the dump file to database 'my_db'
  community.general.mssql_db:
    name: my_db
    state: import
    target: /tmp/dump.sql

Authors

Vedit Firat Arig (@vedit)

© 2012–2018 Michael DeHaan
© 2018–2021 Red Hat, Inc.
Licensed under the GNU General Public License version 3.
https://docs.ansible.com/ansible/2.11/collections/community/general/mssql_db_module.html