az sql

Manage databases.

Manage a database's advanced threat protection setting.

Gets an advanced threat protection setting.

Update a database's advanced threat protection setting.

Manage a database's auditing policy.

Show database audit policy.

Update a database's auditing policy.

Place the CLI in a waiting state until a condition of the database's audit policy is met.

Manage sensitivity classifications.

Delete the sensitivity classification of a given column.

Get the sensitivity classifications of a given database.

Manage sensitivity classification recommendations.

Disable sensitivity recommendations for a given column (recommendations are enabled by default on all columns).

Enable sensitivity recommendations for a given column (recommendations are enabled by default on all columns).

List the recommended sensitivity classifications of a given database.

Get the sensitivity classification of a given column.

Update a columns's sensitivity classification.

Create a copy of a database.

Create a database.

Delete a database.

Export a database to a bacpac.

Manage SQL database geo redundant backups.

Gets a list of recoverable databases.

Restore a geo-redundant backup to a new database.

Gets a recoverable database, which is a resource representing a database's geo backup.

Imports a bacpac into an existing database.

Manage ledger digest upload settings.

Disable uploading ledger digests.

Enable uploading ledger digests to an Azure Storage account or to Azure Confidential Ledger. If uploading ledger digests is already enabled, the cmdlet resets the digest storage endpoint to a new value.

Show the current ledger digest settings.

List databases on a server or elastic pool.

Gets a list of restorable dropped databases.

Show database editions available for the currently active subscription.

Gets database usages.

Manage SQL database long term retention backups.

Delete a long term retention backup.

List the long term retention backups for a location, server or database.

Restore a long term retention backup to a new database.

Get a long term retention backup for a database.

Place the CLI in a waiting state until a condition of the database is met.

Manage SQL database long term retention policy.

Update long term retention settings for a database.

Show the long term retention policy for a database.

Manage operations on a database.

Cancels the asynchronous operation on the database.

Gets a list of operations performed on the database.

Rename a database.

Manage replication between databases.

Create a database as a readable secondary replica of an existing database.

Permanently stop data replication between two database replicas.

List the replicas of a database and their replication status.

Set the primary replica database by failing over from the current primary replica database.

Create a new database by restoring from a backup.

Get the details for a database.

Generates a connection string to a database.

Get the details for a deleted database.

Manage SQL database short term retention policy.

Update short term retention settings for a live database.

Show the short term retention policy for a live database.

Place the CLI in a waiting state until the policy is set.

Manage a database's transparent data encryption.

Manage a database's encryption protector.

Revalidates a database's encryption protector key.

Reverts a database's encryption protector key to server level.

Sets a database's transparent data encryption configuration.

Shows a Transparent Data Encryption.

Manage a database's threat detection policies.

Gets a threat detection policy.

Update a database's threat detection policy.

Update a database.

Delete the SQL server and its cached information.

Manage data warehouses.

Create a data warehouse.

Delete a data warehouse.

List data warehouses for a server.

Pauses a datawarehouse.

Resumes a datawarehouse.

Get the details for a data warehouse.

Update a data warehouse.

Manage elastic pools.

Create an elastic pool.

Deletes an elastic pool.

Gets all elastic pools in a server.

Gets a list of databases in an elastic pool.

List elastic pool editions available for the active subscription.

Manage operations on an elastic pool.

Cancels the asynchronous operation on the elastic pool.

Gets a list of operations performed on the elastic pool.

Gets an elastic pool.

Update an elastic pool.

Manage SQL Failover Groups.

Creates a failover group.

Deletes a failover group.

Lists the failover groups in a server.

Set the primary of the failover group by failing over all databases from the current primary server.

Gets a failover group.

Updates the failover group.

Manage SQL Instance Failover Groups.

Creates an instance failover group between two connected managed instances.

Deletes a failover group.

Set the primary of the instance failover group by failing over all databases from the current primary managed instance.

Gets a failover group.

Updates the instance failover group.

Create or Delete a Failover Group.

Create a failover group resource.

Delete a failover group resource on a SQL managed instance.

Show a failover group resource.

Update a failover group resource.

Manage instance pools.

Create an instance pool.

Delete an instance pool.

List available instance pools.

Get the details for an instance pool.

Update an instance pool.

Wait for an instance pool to reach a desired state.

Gets all subscription usage metrics in a given location.

Manage SQL managed instances.

Manage a managed instance's Active Directory administrator.

Creates a new managed instance Active Directory administrator.

Deletes an existing managed instance Active Directory Administrator.

Returns a list of managed instance Active Directory Administrators.

Updates an existing managed instance Active Directory administrator.

Manage a Managed Instance's Azure Active Directory only settings.

Disable Azure Active Directory only Authentication for this Managed Instance.

Enable Azure Active Directory only Authentication for this Managed Instance.

Get a specific Azure Active Directory only Authentication property.

Manage a SQL managed instance's advanced threat protection setting.

Gets an advanced threat protection setting.

Update a SQL managed instance's advanced threat protection setting.

Create a managed instance.

Delete a managed instance.

Commands related to managed instance DTC management.

Get managed instance DTC settings.

Update managed instance DTC settings.

Place the CLI in a waiting state until a condition is met.

Endpoint certificates management commands.

List certificates used on endpoints on the target instance.

Get a certificate used on the endpoint with the given id.

Failover a managed instance.

Manage a SQL Instance's keys.

Creates a SQL Instance key.

Deletes a SQL Instance key.

Gets a list of managed instance keys.

Shows a SQL Instance key.

Instance link management commands.

Create a distributed availability group between Sql On-Prem and Sql Managed Instance.

Drop a distributed availability group between Sql On-Prem and Sql Managed Instance.

Get a list of a distributed availability groups in instance.

Get a distributed availability group info.

Update a distributed availability group between Sql On-Prem and Sql Managed Instance.

List available managed instances.

Manage operations on a managed instance.

Cancels the asynchronous operation on the managed instance.

Gets a list of operations performed on the managed instance.

Gets a management operation on a managed instance.

Server trust certificate management commands.

Upload a server trust certificate from box to Sql Managed Instance.

Delete a server trust certificate that was uploaded from box to Sql Managed Instance.

Get a list of server trust certificates that were uploaded from box to the given Sql Managed Instance.

Get a server trust certificate that was uploaded from box to Sql Managed Instance.

Get the details for a managed instance.

Manage a SQL Instance's encryption protector.

Sets the SQL Instance's encryption protector.

Shows a server encryption protector.

Update a managed instance.

Manage Azure Arc-enabled SQL managed instances.

Configuration commands.

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

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

Patch a config file based on a json patch file.

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

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

Create a SQL managed instance.

Delete a SQL managed instance.

Deprecated, use update over edit.

View and manage SQL endpoints.

List the SQL endpoints.

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

List SQL managed instances.

Reprovision a replica in a SQL managed instance.

Show the details of a SQL managed instance.

Update the configuration of a SQL managed instance.

Upgrade SQL managed instance.

Manage SQL managed instance databases.

Manage a SQL managed instance database's advanced threat protection setting.

Gets an advanced threat protection setting.

Update a SQL managed instance database's advanced threat protection setting.

Create a managed database.

Delete a managed database.

List managed databases on a managed instance.

List restorable deleted managed databases.

SQL Managed Instance database Log Replay service commands.

Complete Log Replay service on specified database.

Get status of Log Replay service.

Start Log Replay service on specified database.

Stop Log Replay service.

Place the CLI in a waiting state until a condition of the managed database is met.

Manage SQL Managed Instance database long term retention backups.

Delete a long term retention backup.

List the long term retention backups for a location, instance or database.

Restore a long term retention backup to a new database.

Get a long term retention backup for a managed database.

Place the CLI in a waiting state until a condition of the managed database is met.

Manage SQL Managed Instance database long term retention policy.

Update long term retention settings for a managed database.

Show the long term retention policy for a managed database.

Recover a managed database using geo-pair instance backup.

Restore a managed database.

Manage SQL Managed Instance database backup short term retention policy.

Update short term retention for automated backups on a single database.

Show short term retention for automated backups on a single database.

Get the details for a managed database.

Update a managed database.

Manage databases for Azure Arc-enabled SQL managed instances.

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

Recoverable managed databases command group.

Get all recoverable managed databases for given instance name.

Get recoverable managed database.

Manage SQL servers.

Manage a server's Active Directory administrator.

Create a new server Active Directory administrator.

Sets a server's AD admin.

Gets a list of Azure Active Directory administrators in a server.

Update an existing server Active Directory administrator.

Manage Azure Active Directory only Authentication settings for this Server.

Disable Azure Active Directory only Authentication for this Server.

Enable Azure Active Directory only Authentication for this Server.

Get a specific Azure Active Directory only Authentication property.

Manage a server's advanced threat protection setting.

Gets an advanced threat protection setting.

Update a server's advanced threat protection setting.

Manage a server's auditing policy.

Show server audit policy.

Update a server's auditing policy.

Place the CLI in a waiting state until a condition of the server's audit policy is met.

Manage a server's connection policy.

Gets a server's secure connection policy.

Updates a server's secure connection policy.

Create a server.

Deletes a server.

Manage a server's DNS aliases.

Creates a server DNS alias.

Deletes the server DNS alias with the given name.

Gets a list of server DNS aliases for a server.

Sets a server to which DNS alias should point.

Gets a server DNS alias.

Manage a server's firewall rules.

Create a firewall rule.

Deletes a firewall rule.

List a server's firewall rules.

Shows the details for a firewall rule.

Update a firewall rule.

Manage a server's ipv6 firewall rules.

Create an ipv6 firewall rule.

Deletes an IPv6 firewall rule.

List a server's ipv6 firewall rules.

Shows the details for an ipv6 firewall rule.

Update an ipv6 firewall rule.

Manage a server's keys.

Creates a server key.

Deletes a server key.

Gets a list of server keys.

Shows a server key.

List available servers.

Returns server usages.

Manage a server's Microsoft support operations.

Manage a server's Microsoft support operations auditing policy.

Show server Microsoft support operations audit policy.

Update a server's Microsoft support operations auditing policy.

Place the CLI in a waiting state until a condition of the server's Microsoft support operations audit policy is met.

Manage a server's outbound firewall rules.

Create a new outbound firewall rule.

Delete the outbound firewall rule.

List a server's outbound firewall rules.

Show the details for an outbound firewall rule.

Gets a server.

Manage a server's encryption protector.

Revalidate a server encryption protector.

Sets the server's encryption protector. Ensure to create the key first https://docs.microsoft.com/en-us/cli/azure/sql/server/key?view=azure-cli-latest#az-sql-server-key-create.

Gets a server encryption protector.

Update a server.

Manage a server's virtual network rules.

Create a virtual network rule to allows access to an Azure SQL Server.

Deletes the virtual network rule with the given name.

Gets a list of virtual network rules in a server.

Gets a virtual network rule.

Update a virtual network rule.

Place the CLI in a waiting state until a condition of the SQL server is met.

Gets a subscription usage metric.

Manage Server Trust Groups.

Create a Server Trust Group.

Delete a Server Trust Group.

Retrieve a list of Server Trust Groups.

Retrieve a Server Trust Group.

Set up an Azure Database for SQL server and configurations.

Manage SQL virtual clusters.

Delete a virtual cluster.

List available virtual clusters.

Get the details for a virtual cluster.

Manage SQL virtual machines.

Adds SQL virtual machine to a SQL virtual machine group.

Creates a SQL virtual machine.

Deletes a SQL virtual machine.

Enable Azure AD authentication of a SQL virtual machine.

Manage SQL virtual machine groups.

Manage SQL availability group listeners.

Creates an availability group listener.

Deletes an availability group listener.

Lists all availability group listeners in a SQL virtual machine group.

Gets an availability group listener.

Updates an availability group listener.

Creates a SQL virtual machine group.

Deletes a SQL virtual machine group.

Lists all SQL virtual machine groups in a resource group or subscription.

Gets a SQL virtual machine group.

Updates a SQL virtual machine group if there are not SQL virtual machines attached to the group.

Lists all SQL virtual machines in a resource group or subscription.

Remove SQL virtual machine from its current SQL virtual machine group.

Gets a SQL virtual machine.

Starts SQL best practice assessment on SQL virtual machine.

Updates the properties of a SQL virtual machine.

Validate Azure AD authentication of a SQL virtual machine at the client side without enabling it.