az sql

Note

This reference is part of the arcdata extension for the Azure CLI (version 2.3.1 or higher). The extension will automatically install the first time you run an az sql command. Learn more about extensions.

Manage Azure SQL Databases and Data Warehouses.

Commands

Name Description Type Status
az sql db-arc

Manage databases for Azure Arc-enabled SQL Server instance.

Extension Preview
az sql db-arc backups-policy

Manage backups policy.

Extension Preview
az sql db-arc backups-policy delete

Delete your current backups policy.

Extension Preview
az sql db-arc backups-policy set

Set your backups policy.

Extension Preview
az sql db-arc backups-policy show

See your current backups policy.

Extension Preview
az sql db-arc restore

Restore a database from the built-in automatic backups.

Extension Preview
az sql instance-failover-group-arc

Manage Arc-enabled SQL managed instance Failover Groups.

Extension GA
az sql instance-failover-group-arc create

Create a failover group resource.

Extension GA
az sql instance-failover-group-arc delete

Delete an Arc-enabled SQL Managed Instance failover group.

Extension GA
az sql instance-failover-group-arc list

List all failover groups.

Extension GA
az sql instance-failover-group-arc show

Show the details of a failover group resource.

Extension GA
az sql instance-failover-group-arc update

Update a failover group resource.

Extension GA
az sql mi-arc

Manage Azure Arc-enabled SQL managed instances.

Extension GA
az sql mi-arc config

Configuration commands.

Extension GA
az sql mi-arc config add

Add a value for a json path in a config file.

Extension GA
az sql mi-arc config init

Initialize the CRD and specification files for a SQL managed instance.

Extension GA
az sql mi-arc config patch

Patch a config file based on a json patch file.

Extension GA
az sql mi-arc config remove

Remove a value for a json path in a config file.

Extension GA
az sql mi-arc config replace

Replace a value for a json path in a config file.

Extension GA
az sql mi-arc create

Create a SQL managed instance.

Extension GA
az sql mi-arc delete

Delete a SQL managed instance.

Extension GA
az sql mi-arc endpoint

View and manage SQL endpoints.

Extension GA
az sql mi-arc endpoint list

List the SQL endpoints.

Extension GA
az sql mi-arc get-mirroring-cert

Retrieve certificate of availability group mirroring endpoint from sql mi and store in a file.

Extension GA
az sql mi-arc list

List SQL managed instances.

Extension GA
az sql mi-arc reprovision-replica

Reprovision a replica in a SQL managed instance.

Extension GA
az sql mi-arc show

Show the details of a SQL managed instance.

Extension GA
az sql mi-arc update

Update the configuration of a SQL managed instance.

Extension GA
az sql mi-arc upgrade

Upgrade SQL managed instance.

Extension GA
az sql midb-arc

Manage databases for Azure Arc-enabled SQL managed instances.

Extension GA
az sql midb-arc restore

Restore a database to an Azure Arc enabled SQL managed instance.

Extension GA
az sql server-arc

Manage SQL Server enabled by Azure Arc.

Extension GA
az sql server-arc availability-group

Manage availability groups.

Extension Preview
az sql server-arc availability-group create

Create an availability group.

Extension Preview
az sql server-arc availability-group failover

Request manual failover of an availability group.

Extension Preview
az sql server-arc backups-policy

Manage backups policy.

Extension Preview
az sql server-arc backups-policy delete

Delete your current backups policy.

Extension Preview
az sql server-arc backups-policy set

Set your backups policy.

Extension Preview
az sql server-arc backups-policy show

See your current backups policy.

Extension Preview
az sql server-arc extension

Manage extension level properties.

Extension Preview
az sql server-arc extension feature-flag

Manage extension level feature flags.

Extension Preview
az sql server-arc extension feature-flag delete

Delete feature flag.

Extension Preview
az sql server-arc extension feature-flag set

Set feature flag.

Extension Preview
az sql server-arc extension feature-flag show

Show feature flag.

Extension Preview
az sql server-arc extension set

Update common host properties.

Extension Preview
az sql server-arc extension show

Show host properties.

Extension Preview