Azure CLI samples for Azure SQL Database and SQL Managed Instance
Applies to: Azure SQL Database Azure SQL Managed Instance
You can configure Azure SQL Database and SQL Managed Instance by using the Azure CLI.
If you prefer to run CLI reference commands locally, install the Azure CLI. If you are running on Windows or macOS, consider running Azure CLI in a Docker container. For more information, see How to run the Azure CLI in a Docker container.
If you're using a local installation, sign in to the Azure CLI by using the az login command. To finish the authentication process, follow the steps displayed in your terminal. For additional sign-in options, see Sign in with the Azure CLI.
When you're prompted, install Azure CLI extensions on first use. For more information about extensions, see Use extensions with the Azure CLI.
The following table includes links to Azure CLI script examples to manage single and pooled databases in Azure SQL Database.
|Create a single database||Creates an SQL Database and configures a server-level firewall rule.|
|Create pooled databases||Creates elastic pools, moves pooled databases, and changes compute sizes.|
|Scale a single database||Scales single database.|
|Scale pooled database||Scales a SQL elastic pool to a different compute size.|
|Single database||Configures active geo-replication for a database in Azure SQL Database and fails it over to the secondary replica.|
|Pooled database||Configures active geo-replication for a database in an elastic pool, then fails it over to the secondary replica.|
|Configure failover group|
|Configure failover group||Configures a failover group for a group of databases and failover over databases to the secondary server.|
|Single database||Creates a database and a failover group, adds the database to the failover group, then tests failover to the secondary server.|
|Pooled database||Creates a database, adds it to an elastic pool, adds the elastic pool to the failover group, then tests failover to the secondary server.|
|Back up, restore, copy, and import a database|
|Back up a database||Backs up a database in SQL Database to an Azure storage backup.|
|Restore a database||Restores a database in SQL Database to a specific point in time.|
|Copy a database to a new server||Creates a copy of an existing database in SQL Database in a new server.|
|Import a database from a BACPAC file||Imports a database to SQL Database from a BACPAC file.|
Learn more about the single-database Azure CLI API.
Submit and view feedback for