azure-cli-sql

Microsoft Azure CLI 'SQL' Command Module

.. :changelog:

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.