Skip to content

Instantly share code, notes, and snippets.

@trondhindenes
Created March 25, 2018 08:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save trondhindenes/fdaec58df16b317dca2b254d8deffa4f to your computer and use it in GitHub Desktop.
Save trondhindenes/fdaec58df16b317dca2b254d8deffa4f to your computer and use it in GitHub Desktop.
example of using the mssql role to provision RDS databases
- name: do sql things
hosts: sqlserver_jumphost
tasks:
- name: doit
include_role:
name: rikstv_windows_mssqlconfig
vars:
admin_login: "superduperadmin"
admin_password: "superduperpassword"
sql_server_name: "super-duper-mssql01.eu-west-1.rds.amazonaws.com"
sql_logins:
-
username: "svcsql_db1user"
password: "IcanHazC0nfigs"
-
username: "svcsql_db2user"
password: "IcanHazC0nfigs"
sql_databases:
-
database_name: "db1"
owner: "svcsql_db1user"
-
database_name: "db2"
owner: "svcsql_db2user"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment