Microsoft Azure Command-Line Tools SQL Command Module

Navigation

Verified details

These details have been verified by PyPI
Maintainers
Avatar for azpycli from gravatar.com azpycli Avatar for microsoft from gravatar.com microsoft

Unverified details

These details have not been verified by PyPI
Project links
Meta
Classifiers

Project description

Microsoft Azure CLI ‘SQL’ Command Module

Release History

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.

Project details

Verified details

These details have been verified by PyPI
Maintainers
Avatar for azpycli from gravatar.com azpycli Avatar for microsoft from gravatar.com microsoft

Unverified details

These details have not been verified by PyPI
Project links
Meta
Classifiers

Release history Release notifications | RSS feed

2.2.5

2.2.4

2.2.3

2.2.2

2.2.1

2.2.0

2.1.9

2.1.8

2.1.7

2.1.6

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.1.0

2.0.27

This version

2.0.26

2.0.25

2.0.24

2.0.23

2.0.22

2.0.21

2.0.20

2.0.19

2.0.18

2.0.17

2.0.16

2.0.15

2.0.14

2.0.13

2.0.12

2.0.11

2.0.10

2.0.9

2.0.8

2.0.7

2.0.6

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

0.1.1b6 pre-release

0.1.1b5 pre-release

0.1.1b4 pre-release

0.1.1b3 pre-release

0.1.1b2 pre-release

0.1.1b1 pre-release

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

azure-cli-sql-2.0.26.tar.gz (31.1 kB view details)

Uploaded Source

Built Distribution

azure_cli_sql-2.0.26-py2.py3-none-any.whl (33.8 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file azure-cli-sql-2.0.26.tar.gz.

File metadata

File hashes

Hashes for azure-cli-sql-2.0.26.tar.gz
Algorithm Hash digest
SHA256 cebce53561b25fd5e8e9a08899dcbcdbaceba585a66d9d66f1633f15d6011145
MD5 7cc46c3487c051ec2b1a84e4edfe3e6a
BLAKE2b-256 e978122cb2d27a609ca95ea717492130fc73f48b7d4022424206bb48f1332a0a

See more details on using hashes here.

File details

Details for the file azure_cli_sql-2.0.26-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for azure_cli_sql-2.0.26-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 b547f5c3cec54b81c7ddf4e4b3bd3a8b6b22d5a853bfd0e2a100fb15a1460e3a
MD5 43d5ef2f4a1f9562b59c86de702ec330
BLAKE2b-256 4794a0d75286e4a7e3080ad368fbfcbefbdca0808c353101bd952b181feb44c8

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page