azure-cli-sql 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

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.

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

Minor fixes

Support Autorest 3.0 based SDKs

Added zone redundancy support for databases and elastic pools on creation and update.

Added az sql server dns-alias commands.

Added az sql db rename

Support –ids argument for db, dw, server, elastic-pool, and server firewall-rule commands.

Updated helpfile

Update for CLI core changes.

Update managed storage SDK dependency

Added az sql db list-usages and az sql db show-usage commands.

Added sql server conn-policy show/update commands.

Added –ignore-missing-vnet-service-endpoint param to az sql server vnet-rule create and update commands

Minor fixes.

Minor fixes

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.

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

Added az sql server vnet-rule commands.

minor fixes

minor fixes

minor fixes

Removed broken az sql server create –identity parameter.

az sql server create/update command output no longer show administratorLoginPassword values.

Added az sql db list-editions and az sql elastic-pool list-editions commands.

Minor fixes.

Minor fixes.

Added az sql server list-usages and az sql db list-usages commands.

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)

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)

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)

Parameter help fix.

Documentation updates.

Fix SQL command aliases.

Support Python 3.6.

Fix incorrect sql parameter register

Expanding ElasticPool while creating elastic-pool

Fix incorrect type of subgroup in help

Add Azure SQL Server commands.

Preview release.