Microsoft Azure CLI ‘SQL’ Command Module
Release History
2.2.5
az sql server create, az sql mi create: make location optional. If unspecified, use resource group location.
2.2.4
Minor fixes
2.2.3
Added commands sql virtual-cluster list/show/delete
Upgrade azure-mgmt-storage from 3.1.1 to 3.3.0
Fixed “‘NoneType’ object is not iterable” error for az sql db list-editions –available.
2.2.2
Support for custom time zone on managed instance.
Allow elastic pool name (as an alternative to elastic pool id) to be specified for az sql db update.
sql server create/update: Added –no-wait support.
sql server: Added new command wait.
2.2.1
Updating az sql mi create and update with two new properties (proxyOverride and publicDataEndpointEnabled)
2.2.0
Minor fixes
2.1.9
Minor fixes
2.1.8
Minor fixes
2.1.7
Updating dependencies
2.1.6
Support for custom collation on managed instance.
2.1.5
Fixed az sql failover-group create and az sql failover-group update to work with Manual failover policy.
2.1.4
Minor fixes
2.1.3
Minor fixes
2.1.2
Minor fixes.
2.1.1
Minor fixes.
Added az sql failover-group commands.
2.1.0
BREAKING CHANGE: ‘show’ commands log error message and fail with exit code of 3 upon a missing resource.
Fixed ‘The provided resource group name … did not match the name in the Url’ error when specifying elastic pool name for sql db copy and sql db replica create commands.
Allow configuring default sql server by executing az configure –defaults sql-server=<name>.
Implemented table formatters for ‘sql server’, ‘sql server firewall-rule’, ‘sql list-usages’, and ‘sql show-usage’ commands. Use ‘-o table’ to format output as a table.
2.0.28
Minor fixes.
2.0.27
- Added new Managed instance and Managed database CRUD commands.
- Managed instance commands:
az sql mi create
az sql mi show
az sql mi list
az sql mi update
az sql mi delete
- Managed database commands:
az sql midb create
az sql midb show
az sql midb list
az sql midb restore
az sql midb delete
Fixed confusing error when running az sql db list-editions for a location that is not available to your subscription.
2.0.26
- BREAKING CHANGES: Updated database, data warehouse, and elastic pool commands to use Azure-standard SKU properties for configuring performance level. This has resulted in some changes to the respose objects returned from db, dw, and elastic-pool commands.
- Database & data warehouse respose objects:
“serviceLevelObjective” property renamed to “currentServiceObjectiveName”
“currentServiceObjectiveId” and “requestedServiceObjectiveId” properties removed
“requestedServiceObjectiveName” property is now readonly. To update service objective, use –service-objective parameter or set sku.name property.
“edition” property is now readonly. To update edition, use –edition parameter or set sku.tier property.
“elasticPoolName” property is now readonly. To update elastic pool, use –elastic-pool parameter or set elasticPoolId property.
“maxSizeBytes” property is now an integer value instead of a string.
Elastic pool respose objects: * “edition”, “dtu”, “databaseDtuMin”, and “databaseDtuMax” properties are now readonly. To update, use –edition, –capacity, –db-max-capacity, and –db-min-capacity parameters respectively.
Database, data warehouse, and elastic pool create and update commands now accept parameters to set the family (i.e. compute generation) and capacity (i.e. scale) aspects of performance level. Capacity can be used to set the scale of DTU-based editions (e.g. Basic, Standard, Premium), and family & capacity can be used to set the scale of vcore-based editions (e.g. GeneralPurpose and BusinessCritical).
Database, data warehouse, and elastic pool commands now have table formatters (for use with -o table) which provide a more compact view of their major properties.
2.0.25
Use new release azure-mgmt-sql 0.8.6 SDK Python package
Added az sql elastic-pool op list and az sql elastic-pool op cancel, Support list and cancel azure sql elastic pool operations
sdist is now compatible with wheel 0.31.0
2.0.24
Minor fixes
2.0.23
Support Autorest 3.0 based SDKs
2.0.22
Added zone redundancy support for databases and elastic pools on creation and update.
2.0.21
Added az sql server dns-alias commands.
2.0.20
Added az sql db rename
Support –ids argument for db, dw, server, elastic-pool, and server firewall-rule commands.
2.0.19
Updated helpfile
2.0.18
Update for CLI core changes.
2.0.17
Update managed storage SDK dependency
2.0.16
Added az sql db list-usages and az sql db show-usage commands.
Added sql server conn-policy show/update commands.
2.0.15
Added –ignore-missing-vnet-service-endpoint param to az sql server vnet-rule create and update commands
Minor fixes.
2.0.14
Minor fixes
2.0.13 (2017-10-09)
Adding support for SQL Transparent Data Encryption (TDE) and TDE with Bring Your Own Key
Added az sql db list-deleted command and az sql db restore –deleted-time parameter, allowing the ability to find and restore deleted databases.
Added az sql db op list and az sql db op cancel, allowing the ability to list and cancel in-progress operations on database.
2.0.12 (2017-09-22)
az sql server list –resource-group argument is now optional. If not specified, all sql servers in the entire subscription will be returned.
Added –no-wait param to db create, db copy, db restore, db update, db replica create, dw create, and dw update commands
2.0.11 (2017-09-11)
Added az sql server vnet-rule commands.
2.0.10 (2017-08-28)
minor fixes
2.0.9 (2017-08-11)
minor fixes
2.0.8 (2017-07-27)
minor fixes
2.0.7 (2017-07-07)
Removed broken az sql server create –identity parameter.
2.0.6 (2017-06-21)
az sql server create/update command output no longer show administratorLoginPassword values.
2.0.5 (2017-06-13)
Added az sql db list-editions and az sql elastic-pool list-editions commands.
2.0.4 (2017-05-30)
Minor fixes.
2.0.3 (2017-05-09)
Minor fixes.
2.0.2 (2017-04-28)
Added az sql server list-usages and az sql db list-usages commands.
2.0.1 (2017-04-17)
SQL - ability to connect directly to resource provider (#2832)
Fix doc references to azure.cli.commands (#2740)
Apply core changes required for API profile support (#2834) & JSON string parsing from shell (#2705)
2.0.0 (2017-04-03)
Removed duplicate sql utils code (#2629)
Import/Export CLI changes for SAS key (#2584)
SQL database audit and threat detection commands (#2536)
Sql Import/Export CLI commands and test (#2538)
Require confirmation for destructive SQL commands. (#2509)
0.1.1b6 (2017-03-13)
Design changes and tests for SQL DB replication commands (#2379)
Design tweaks and functional test for SQL db restore command (#2423)
Implemented and tested SQL Data Warehouse commands (#2351)
Removed service-objective commands. (#2380)
SQL core commands (server, db, and elastic pool) (#2253)
0.1.1b5 (2017-02-27)
Parameter help fix.
0.1.1b4 (2017-02-22)
Documentation updates.
0.1.1b3 (2017-01-30)
Fix SQL command aliases.
Support Python 3.6.
0.1.1b2 (2017-01-19)
Fix incorrect sql parameter register
Expanding ElasticPool while creating elastic-pool
Fix incorrect type of subgroup in help
0.1.1b1 (2017-01-17)
Add Azure SQL Server commands.
0.1.0b11 (2016-12-12)
Preview release.
Release files for azure-cli-sql 2.2.5
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| azure-cli-sql-2.2.5.tar.gz | 40.6 kB | Without provenance | Details for azure-cli-sql-2.2.5.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| azure_cli_sql-2.2.5-py2.py3-none-any.whl | Python 3, Python 2 | none | any | Details for azure_cli_sql-2.2.5-py2.py3-none-any.whl |
Total release size: 81.8 kB
Release files / azure-cli-sql-2.2.5.tar.gz
| Download URL | azure-cli-sql-2.2.5.tar.gz |
|---|---|
| Size | 40.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
6da3a23d05d2d77c3ba3212509254918e18fe0e2cdbff2a66c81a65a819ac487
|
|
BLAKE2b-256 checksum How to use checksums |
a75871c99caff05d15d43aea5108f9f1d459a6357b4318d846f6126586e0d505
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.7.3
|
Release files / azure_cli_sql-2.2.5-py2.py3-none-any.whl
| Download URL | azure_cli_sql-2.2.5-py2.py3-none-any.whl |
|---|---|
| Size | 41.1 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
8fd8da72924b08b84f436f4ad412bcf72c170b9389cd647bceef699322847fde
|
|
BLAKE2b-256 checksum How to use checksums |
3b53735dfbbb984c05ff066de9f8db984a51c57ac2331d40c882056271cec03a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.7.3
|
Security for azure-cli-sql 2.2.5
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
