| title | Azure CLI samples | ||||||
|---|---|---|---|---|---|---|---|
| description | Find Azure CLI script samples to create and manage Azure SQL Database. | ||||||
| author | WilliamDAssafMSFT | ||||||
| ms.author | wiassaf | ||||||
| ms.reviewer | mathoma | ||||||
| ms.date | 04/30/2024 | ||||||
| ms.service | azure-sql-database | ||||||
| ms.subservice | deployment-configuration | ||||||
| ms.topic | sample | ||||||
| ms.custom |
|
||||||
| keywords |
|
||||||
| ms.devlang | azurecli | ||||||
| monikerRange | = azuresql || = azuresql-db |
[!INCLUDEappliesto-sqldb]
[!div class="op_single_selector"]
You can configure Azure SQL Database by using the Azure CLI.
[!INCLUDE quickstarts-free-trial-note]
[!INCLUDE azure-cli-prepare-your-environment.md]
The following table includes links to Azure CLI script examples to manage single and pooled databases in Azure SQL Database.
| Area | Description |
|---|---|
| Create databases | |
| Create a single database | Creates a SQL Database and configures a server-level firewall rule. |
| Create pooled databases | Creates elastic pools, moves pooled databases, and changes compute sizes. |
| Scale databases | |
| Scale a single database | Scales single database. |
| Scale pooled database | Scales a SQL elastic pool to a different compute size. |
| Configure geo-replication | |
| 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.