blob: d1d8cd91dd6f30261015f5969ba98e39806e973a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
#!/usr/bin/python
# -*- coding: utf-8 -*-
# (c) 2022, John McCall (@lowlydba)
# GNU General Public License v3.0+ (see COPYING or https://www.gnu.org/licenses/gpl-3.0.txt)
DOCUMENTATION = r'''
---
module: database
short_description: Creates and configures a database
description:
- Adds a new database to an existing SQL Server instance.
version_added: 0.1.0
options:
database:
description:
- Name of the target database.
type: str
required: true
recovery_model:
description:
- Choose the recovery model for the database.
type: str
required: false
choices: ['Full', 'Simple', 'BulkLogged']
data_file_path:
description:
- Directory where the data files should be placed. Uses SQL Server's default if not supplied.
- Only used if database is being created.
type: str
required: false
log_file_path:
description:
- Directory where the log files should be placed. Uses SQL Server's default if not supplied.
- Only used if database is being created.
type: str
required: false
owner:
description:
- Database owner login.
type: str
required: false
maxdop:
description:
- MAXDOP value for the database.
required: false
type: int
secondary_maxdop:
description:
- MAXDOP value for the database when it is a non-primary replica in an availability group.
required: false
type: int
compatibility:
description:
- Compatibility mode for the database. Follows the format of C(Version90), C(Version100), and so on.
- String is validated by C(Set-DbaDbCompatibility).
required: false
type: str
rcsi:
description:
- Whether or not to enable Read Committed Snapshot Isolation.
required: false
type: bool
only_accessible:
description:
- Whether or not to enable Read Committed Snapshot Isolation.
default: true
required: false
type: bool
version_added: '2.2.0'
author: "John McCall (@lowlydba)"
requirements:
- L(dbatools,https://www.powershellgallery.com/packages/dbatools/) PowerShell module
extends_documentation_fragment:
- lowlydba.sqlserver.sql_credentials
- lowlydba.sqlserver.attributes.check_mode
- lowlydba.sqlserver.attributes.platform_all
- lowlydba.sqlserver.state
'''
EXAMPLES = r'''
- name: Create database
lowlydba.sqlserver.database:
sql_instance: sql-01.myco.io
database: LowlyDB
- name: Create database with customizations
lowlydba.sqlserver.database:
sql_instance: sql-01.myco.io
database: LowlyDB
owner: sa
maxdop: 2
recovery_model: Simple
'''
RETURN = r'''
data:
description: Modified output from the C(New-DbaDatabase), C(Set-DbaDatabase), or C(Remove-DbaDatabase) function.
returned: success, but not in check_mode.
type: dict
'''
|
