Create Azure SQL Staging | Testing Database
We can do that by copying the current production database on either the same server or a different server using one of the following ways :
1- Using Azure Portal :
Azure SQL >> From the top bar click Copy >> then follow the wizard
==================
2- Using Transact-SQL:
- Log into the Master database and excute this script:
CREATE DATABASE [StagingDatabaseName] AS COPY OF MyServerName.[SourceDatabaseName]
- To monitor the Progress:
SELECT * FROM sys.dm_database_copies
==================
3- Using Azure CLI :
az sql db copy --dest-name "CopyOfMySampleDatabase" --dest-resource-group "myResourceGroup" --dest-server $targetserver `
--name "<databaseName>" --resource-group "<resourceGroup>" --server $sourceserver
==================
4- Using PowerShell:
New-AzSqlDatabaseCopy -ResourceGroupName "<resourceGroup>" -ServerName $sourceserver -DatabaseName "<databaseName>" `
-CopyResourceGroupName "myResourceGroup" -CopyServerName $targetserver -CopyDatabaseName "CopyOfMySampleDatabase"
1 comment:
The food shortage in Michigan? - stillcasino
› › Michigan › › Michigan › Aug 30, 메리트카지노 2021 — Aug 30, 2021 ミスティーノ Michigan's food insecurity in Michigan has been dramatically reducing. The Food and Drug Administration announced it is starvegad recommending an end to the food
Post a Comment