Skip to content

copy-database-to-new-server-cli.md

Latest commit

 

History

History
54 lines (36 loc) · 1.8 KB

copy-database-to-new-server-cli.md

File metadata and controls

54 lines (36 loc) · 1.8 KB
title Azure CLI example: Copy database in Azure SQL Database to new server
description Use this Azure CLI example script to copy a database in Azure SQL Database to a new server
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer mathoma
ms.date 01/26/2022
ms.service sql-database
ms.subservice data-movement
ms.topic sample
ms.custom devx-track-azurecli
ms.devlang azurecli

Copy a database in Azure SQL Database to a new server using the Azure CLI

[!INCLUDEappliesto-sqldb]

This Azure CLI script example creates a copy of an existing database in a new server.

[!INCLUDE quickstarts-free-trial-note]

[!INCLUDE azure-cli-prepare-your-environment.md]

Sample script

[!INCLUDE cli-launch-cloud-shell-sign-in.md]

Run the script

:::code language="azurecli" source="~/../azure_cli_scripts/sql-database/copy-database-to-new-server/copy-database-to-new-server.sh" id="FullScript":::

Clean up resources

[!INCLUDE cli-clean-up-resources.md]

az group delete --name $targetResourceGroup
az group delete --name $resourceGroup

Sample reference

This script uses the following commands. Each command in the table links to command specific documentation.

Command Description
az sql db copy Creates a copy of a database that uses the snapshot at the current time.

Next steps

For more information on Azure CLI, see Azure CLI documentation.

Additional SQL Database CLI script samples can be found in the Azure SQL Database documentation.