| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | keywords | ms.devlang | monikerRange | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Azure CLI samples |
Find Azure CLI script samples to create and manage Azure SQL Database. |
WilliamDAssafMSFT |
wiassaf |
mathoma |
04/30/2024 |
azure-sql-database |
deployment-configuration |
sample |
|
|
azurecli |
= 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.