Azure PowerShell samples for Azure SQL Database

The following table includes links to sample Azure PowerShell scripts for Azure SQL Database.

Create a single database and an elastic pool
Create a single database and configure a firewall rule This PowerShell script creates a single Azure SQL database and configures a server-level firewall rule.
Create elastic pools and move pooled databases This PowerShell script creates Azure SQL Database elastic pools, and moves pooled databases, and changes performance levels.
Configure geo-replication and failover
Configure and failover a single database using active geo-replication This PowerShell script configures active geo-replication for a single Azure SQL database and fails it over to the secondary replica.
Configure and failover a pooled database using active geo-replication This PowerShell script configures active geo-replication for an Azure SQL database in a SQL elastic pool, and fails it over to the secondary replica.
Configure and failover a failover group for a single database (preview) This PowerShell script configures a failover group for an Azure SQL Database server instance, adds a database to the failover group, and fails it over to the secondary server
Scale a single databases and an elastic pool
Scale a single database This PowerShell script monitors the performance metrics of an Azure SQL database, scales it to a higher performance level and creates an alert rule on one of the performance metrics.
Scale an elastic pool This PowerShell script monitors the performance metrics of an Azure SQL Database elastic pool, scales it to a higher performance level, and creates an alert rule on one of the performance metrics.
Auditing and threat detection
Configure auditing and threat-detection This PowerShell script configures auditing and threat detection policies for an Azure SQL database.
Restore, copy, and import a database
Restore a database This PowerShell script restores an Azure SQL database from a geo-redundant backup and restores a deleted Azure SQL database to the latest backup.
Copy a database to new server This PowerShell script creates a copy of an existing Azure SQL database in a new Azure SQL server.
Import a database from a bacpac file This PowerShell script imports a database to an Azure SQL server from a bacpac file.
Sync data between databases
Sync data between SQL databases This PowerShell script configures Data Sync to sync between multiple Azure SQL databases.
Sync data between SQL Database and SQL Server on-premises This PowerShell script configures Data Sync to sync between an Azure SQL database and a SQL Server on-premises database.