forked from MicrosoftDocs/azure-docs-cli
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdb.pycliyml
More file actions
443 lines (443 loc) · 16 KB
/
db.pycliyml
File metadata and controls
443 lines (443 loc) · 16 KB
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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
commandList:
- name: az sql db create
description: Create an Azure SQL database.
href: db#create
- name: az sql db data-warehouse
description: Manage database data warehouse.
href: db/data-warehouse
isGroup: true
- name: az sql db data-warehouse pause
description: Pause an Azure SQL Data Warehouse database.
href: db/data-warehouse#pause
- name: az sql db data-warehouse resume
description: Resume an Azure SQL Data Warehouse database.
href: db/data-warehouse#resume
- name: az sql db delete
description: Deletes an Azure SQL database.
href: db#delete
- name: az sql db list
description: Returns information about an Azure SQL database.
href: db#list
- name: az sql db replication-link
description: Manage database replication links.
href: db/replication-link
isGroup: true
- name: az sql db replication-link delete
description: Deletes the Azure SQL database replication link with the given ID.
href: db/replication-link#delete
- name: az sql db replication-link failover
description: Failover the Azure SQL database replication link with the given ID.
href: db/replication-link#failover
- name: az sql db replication-link force-failover
description: Force failover the Azure SQL database replication link with the given ID which may result in data loss.
href: db/replication-link#force-failover
- name: az sql db replication-link list
description: Gets information about Azure SQL database replication links.
href: db/replication-link#list
- name: az sql db replication-link show
description: Gets information about an Azure SQL database replication link.
href: db/replication-link#show
- name: az sql db restore-point
description: Manage database restore points.
href: db/restore-point
isGroup: true
- name: az sql db restore-point list
description: Returns a list of Azure SQL database restore points.
href: db/restore-point#list
- name: az sql db service-tier-advisor
description: Manage database service tier advisors.
href: db/service-tier-advisor
isGroup: true
- name: az sql db service-tier-advisor list
description: Returns information about service tier advisors for specified database.
href: db/service-tier-advisor#list
- name: az sql db service-tier-advisor show
description: Gets information about a service tier advisor.
href: db/service-tier-advisor#show
- name: az sql db show
description: Gets information about an Azure SQL database.
href: db#show
- name: az sql db show-usage
description: Returns information about Azure SQL database usages.
href: db#show-usage
- name: az sql db transparent-data-encryption
description: Manage database transparent data encryption.
href: db/transparent-data-encryption
isGroup: true
- name: az sql db transparent-data-encryption create
description: Creates or updates an Azure SQL Database Transparent Data Encryption Operation.
href: db/transparent-data-encryption#create
- name: az sql db transparent-data-encryption show-activity
description: Returns an Azure SQL Database Transparent Data Encryption Activity Response.
href: db/transparent-data-encryption#show-activity
- name: az sql db transparent-data-encryption show-configuration
description: Gets an Azure SQL Database Transparent Data Encryption Response.
href: db/transparent-data-encryption#show-configuration
- name: az sql db update
description: ''
href: db#update
htmlId: db
examples: []
source:
remote:
path: src/command_modules/azure-cli-sql/azure/cli/command_modules/sql/help.py
branch: master
repo: https://github.com/Azure/azure-cli.git
children:
- commandList: []
htmlId: create
examples: []
parameters:
- name: --location -l
isRequired: True
summary: Location.
description: ''
- name: --name -n
isRequired: True
summary: The name of the Azure SQL database to be operated on (updated or created).
description: ''
- name: --resource-group -g
isRequired: True
summary: Name of resource group.
description: ''
- name: --server-name
isRequired: True
summary: The name of the Azure SQL server.
description: ''
- name: --collation
isRequired: False
summary: The collation of the Azure SQL database.
description: ''
- name: --create-mode
isRequired: False
summary: Specifies the type of database to create.
description: ''
- name: --edition
isRequired: False
summary: The edition of the Azure SQL database. The DatabaseEditions enumeration contains all the valid editions.
description: ''
- name: --elastic-pool-name
isRequired: False
summary: The name of the Azure SQL Elastic Pool the database is in.
description: ''
- name: --max-size-bytes
isRequired: False
summary: 'The max size of the Azure SQL database expressed in bytes. Note: Only the following sizes are supported (in addition to limitations being placed on each edition): { 100 MB | 500 MB |1 GB | 5 GB | 10 GB | 20 GB | 30 GB … 150 GB | 200 GB … 500 GB }.'
description: ''
- name: --requested-service-objective-id
isRequired: False
summary: The configured Service Level Objective ID of the Azure SQL database. This is the Service Level Objective that is in the process of being applied to the Azure SQL database. Once successfully updated, it will match the value of currentServiceObjectiveId property.
description: ''
- name: --requested-service-objective-name
isRequired: False
summary: The name of the configured Service Level Objective of the Azure SQL database. This is the Service Level Objective that is in the process of being applied to the Azure SQL database. Once successfully updated, it will match the value of serviceLevelObjective property.
description: ''
- name: --source-database-id
isRequired: False
summary: 'Conditional. Specifies the resource ID of the source database. If createMode is not set to Default, then this value must be specified. The name of the source database must be the same. NOTE: Collation, Edition, and MaxSizeBytes must remain the same while the link is active. Values specified for these parameters will be ignored.'
description: ''
- name: --tags
isRequired: False
summary: Resource tags.
description: ''
- name: --debug
isRequired: False
summary: Increase logging verbosity to show all debug logs.
description: ''
- name: --help -h
isRequired: False
summary: Show this help message and exit.
description: ''
- name: --output -o
isRequired: False
summary: Output format.
description: ''
defaultValue: json
parameterValueGroup: json, jsonc, table, tsv
- name: --query
isRequired: False
summary: JMESPath query string. See <a href="http://jmespath.org/">http://jmespath.org/</a> for more information and examples.
description: ''
- name: --verbose
isRequired: False
summary: Increase logging verbosity. Use --debug for full debug logs.
description: ''
source:
remote:
path: src/command_modules/azure-cli-sql/azure/cli/command_modules/sql/help.py
branch: master
repo: https://github.com/Azure/azure-cli.git
children: []
uid: az_sql_db_create
name: az sql db create
description: ''
summary: Create an Azure SQL database.
Metadata: {}
- commandList: []
htmlId: delete
examples: []
parameters:
- name: --name -n
isRequired: True
summary: The name of the Azure SQL database to be deleted.
description: ''
- name: --resource-group -g
isRequired: True
summary: Name of resource group.
description: ''
- name: --server-name
isRequired: True
summary: The name of the Azure SQL server.
description: ''
- name: --debug
isRequired: False
summary: Increase logging verbosity to show all debug logs.
description: ''
- name: --help -h
isRequired: False
summary: Show this help message and exit.
description: ''
- name: --output -o
isRequired: False
summary: Output format.
description: ''
defaultValue: json
parameterValueGroup: json, jsonc, table, tsv
- name: --query
isRequired: False
summary: JMESPath query string. See <a href="http://jmespath.org/">http://jmespath.org/</a> for more information and examples.
description: ''
- name: --verbose
isRequired: False
summary: Increase logging verbosity. Use --debug for full debug logs.
description: ''
source:
remote:
path: src/command_modules/azure-cli-sql/azure/cli/command_modules/sql/help.py
branch: master
repo: https://github.com/Azure/azure-cli.git
children: []
uid: az_sql_db_delete
name: az sql db delete
description: ''
summary: Deletes an Azure SQL database.
Metadata: {}
- commandList: []
htmlId: list
examples: []
parameters:
- name: --resource-group -g
isRequired: True
summary: Name of resource group.
description: ''
- name: --server-name
isRequired: True
summary: The name of the Azure SQL server.
description: ''
- name: --debug
isRequired: False
summary: Increase logging verbosity to show all debug logs.
description: ''
- name: --help -h
isRequired: False
summary: Show this help message and exit.
description: ''
- name: --output -o
isRequired: False
summary: Output format.
description: ''
defaultValue: json
parameterValueGroup: json, jsonc, table, tsv
- name: --query
isRequired: False
summary: JMESPath query string. See <a href="http://jmespath.org/">http://jmespath.org/</a> for more information and examples.
description: ''
- name: --verbose
isRequired: False
summary: Increase logging verbosity. Use --debug for full debug logs.
description: ''
source:
remote:
path: src/command_modules/azure-cli-sql/azure/cli/command_modules/sql/help.py
branch: master
repo: https://github.com/Azure/azure-cli.git
children: []
uid: az_sql_db_list
name: az sql db list
description: ''
summary: Returns information about an Azure SQL database.
Metadata: {}
- commandList: []
htmlId: show
examples: []
parameters:
- name: --name -n
isRequired: True
summary: The name of the Azure SQL database to be retrieved.
description: ''
- name: --resource-group -g
isRequired: True
summary: Name of resource group.
description: ''
- name: --server-name
isRequired: True
summary: The name of the Azure SQL server.
description: ''
- name: --expand
isRequired: False
summary: 'The comma separated list of child objects to expand in the response. Possible properties: serviceTierAdvisors, upgradeHint, transparentDataEncryption.'
description: ''
- name: --debug
isRequired: False
summary: Increase logging verbosity to show all debug logs.
description: ''
- name: --help -h
isRequired: False
summary: Show this help message and exit.
description: ''
- name: --output -o
isRequired: False
summary: Output format.
description: ''
defaultValue: json
parameterValueGroup: json, jsonc, table, tsv
- name: --query
isRequired: False
summary: JMESPath query string. See <a href="http://jmespath.org/">http://jmespath.org/</a> for more information and examples.
description: ''
- name: --verbose
isRequired: False
summary: Increase logging verbosity. Use --debug for full debug logs.
description: ''
source:
remote:
path: src/command_modules/azure-cli-sql/azure/cli/command_modules/sql/help.py
branch: master
repo: https://github.com/Azure/azure-cli.git
children: []
uid: az_sql_db_show
name: az sql db show
description: ''
summary: Gets information about an Azure SQL database.
Metadata: {}
- commandList: []
htmlId: show-usage
examples: []
parameters:
- name: --name -n
isRequired: True
summary: The name of the Azure SQL database.
description: ''
- name: --resource-group -g
isRequired: True
summary: Name of resource group.
description: ''
- name: --server-name
isRequired: True
summary: The name of the Azure SQL server.
description: ''
- name: --debug
isRequired: False
summary: Increase logging verbosity to show all debug logs.
description: ''
- name: --help -h
isRequired: False
summary: Show this help message and exit.
description: ''
- name: --output -o
isRequired: False
summary: Output format.
description: ''
defaultValue: json
parameterValueGroup: json, jsonc, table, tsv
- name: --query
isRequired: False
summary: JMESPath query string. See <a href="http://jmespath.org/">http://jmespath.org/</a> for more information and examples.
description: ''
- name: --verbose
isRequired: False
summary: Increase logging verbosity. Use --debug for full debug logs.
description: ''
source:
remote:
path: src/command_modules/azure-cli-sql/azure/cli/command_modules/sql/help.py
branch: master
repo: https://github.com/Azure/azure-cli.git
children: []
uid: az_sql_db_show-usage
name: az sql db show-usage
description: ''
summary: Returns information about Azure SQL database usages.
Metadata: {}
- commandList: []
htmlId: update
examples: []
parameters:
- name: --name -n
isRequired: True
summary: The name of the Azure SQL database to be retrieved.
description: ''
- name: --resource-group -g
isRequired: True
summary: Name of resource group.
description: ''
- name: --server-name
isRequired: True
summary: The name of the Azure SQL server.
description: ''
- name: --add
isRequired: False
summary: 'Add an object to a list of objects by specifying a path and key value pairs. Example: --add property.listProperty <key=value, string or JSON string>.'
description: ''
- name: --remove
isRequired: False
summary: 'Remove a property or an element from a list. Example: --remove property.list <indexToRemove> OR --remove propertyToRemove.'
description: ''
- name: --set
isRequired: False
summary: 'Update an object by specifying a property path and value to set. Example: --set property1.property2=<value>.'
description: ''
- name: --debug
isRequired: False
summary: Increase logging verbosity to show all debug logs.
description: ''
- name: --help -h
isRequired: False
summary: Show this help message and exit.
description: ''
- name: --output -o
isRequired: False
summary: Output format.
description: ''
defaultValue: json
parameterValueGroup: json, jsonc, table, tsv
- name: --query
isRequired: False
summary: JMESPath query string. See <a href="http://jmespath.org/">http://jmespath.org/</a> for more information and examples.
description: ''
- name: --verbose
isRequired: False
summary: Increase logging verbosity. Use --debug for full debug logs.
description: ''
source:
remote:
path: src/command_modules/azure-cli-sql/azure/cli/command_modules/sql/help.py
branch: master
repo: https://github.com/Azure/azure-cli.git
children: []
uid: az_sql_db_update
name: az sql db update
description: ''
summary: ''
Metadata: {}
uid: az_sql_db
name: 'SQL Databases (Preview) - az sql db'
description: ''
summary: Commands to manage databases.
Metadata:
doc_source_url_repo: https://github.com/Azure/azure-cli/blob/master/
doc_source_url_path: src/command_modules/azure-cli-sql/azure/cli/command_modules/sql/help.py
original_content_git_url: https://github.com/Azure/azure-cli/blob/master/src/command_modules/azure-cli-sql/azure/cli/command_modules/sql/help.py
gitcommit: https://github.com/Azure/azure-cli/blob/714ce68ebb5976d113ae44e72868c4441a7d705f/src/command_modules/azure-cli-sql/azure/cli/command_modules/sql/help.py
updated_at: 1/23/2017 7:00:24 PM
ms.date: 1/23/2017