Copy db from dev to UAT env

Question

Copy db from dev to UAT env

Santhi Dhanuskodi 325

hi,

I need to copy complete db from dev to UAT environment, it is azure sql db.

UAT server is freshly created and setup. How to move db from dev to UAT?

what are the different approaches and best to do this? what important do's and donts?

Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2023-08-30T06:28:04.5866667+00:00
Hey,

Assuming both your servers are in same subscription and tenant and you want to copy the database as is including the data, below URL would help :

https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?view=azuresql&tabs=azure-powershell

https://www.sqlshack.com/four-different-methods-to-copy-your-azure-sql-database/

If you just need to create a replica of DB without data, you would need to extract the dacpac of the dev database and deploy it on new server

The most easy way would be to use portal copy functionality or use powershell :

New-AzSqlDatabaseCopy -ResourceGroupName "<resourceGroup>" -ServerName $sourceserver -DatabaseName "<databaseName>" ` -CopyResourceGroupName "myResourceGroup" -CopyServerName $targetserver -CopyDatabaseName "CopyOfMySampleDatabase"
Santhi Dhanuskodi 325 Reputation points

2023-08-30T06:54:31.4033333+00:00

Thank you!

Its same subscription and sql servers are different. UAT server is created and an empty db say for eg"Test" is created.

I need to copy from 'devserver: testdb" to "uatserver:test" in same subscription.
Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2023-08-30T06:56:32.63+00:00

Hey,So powershell and Portal copy would be the easy way to do that
Santhi Dhanuskodi 325 Reputation points

2023-08-30T07:22:57.54+00:00

Do we have to install powershell in our local machine? Is it windows power shell or any other cloud app?

Also give me details on portal copy
Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2023-08-30T08:08:47.9+00:00

Portal :

Old refernce :

https://www.sqlshack.com/copy-azure-sql-database-using-azure-portal-cloud-shell-t-sql/

for powershell : search windows powershell ISE in your system.
Santhi Dhanuskodi 325 Reputation points

2023-08-30T08:30:08.75+00:00

With Azure portal - copy option doesnt have the UI/feature to copy from one env to another...this is in latest azure portal....
SSingh-MSFT 16,371 Reputation points Moderator

2023-08-31T08:50:27.42+00:00

Hi Santhi Dhanuskodi •,

Just checking if the provided reply helped. If not, please let us know so that we can further assist you.

Thanks

1 answer

Your answer

Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2023-08-30T06:28:04.5866667+00:00

Hey,

Assuming both your servers are in same subscription and tenant and you want to copy the database as is including the data, below URL would help :

https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?view=azuresql&tabs=azure-powershell

https://www.sqlshack.com/four-different-methods-to-copy-your-azure-sql-database/

If you just need to create a replica of DB without data, you would need to extract the dacpac of the dev database and deploy it on new server

The most easy way would be to use portal copy functionality or use powershell :

New-AzSqlDatabaseCopy -ResourceGroupName "<resourceGroup>" -ServerName $sourceserver -DatabaseName "<databaseName>" ` -CopyResourceGroupName "myResourceGroup" -CopyServerName $targetserver -CopyDatabaseName "CopyOfMySampleDatabase"
Santhi Dhanuskodi 325 Reputation points

2023-08-30T06:54:31.4033333+00:00

Thank you!

Its same subscription and sql servers are different. UAT server is created and an empty db say for eg"Test" is created.

I need to copy from 'devserver: testdb" to "uatserver:test" in same subscription.
Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2023-08-30T06:56:32.63+00:00

Hey,So powershell and Portal copy would be the easy way to do that
Santhi Dhanuskodi 325 Reputation points

2023-08-30T07:22:57.54+00:00

Do we have to install powershell in our local machine? Is it windows power shell or any other cloud app?

Also give me details on portal copy
Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2023-08-30T08:08:47.9+00:00

Portal :

Old refernce :

https://www.sqlshack.com/copy-azure-sql-database-using-azure-portal-cloud-shell-t-sql/

for powershell : search windows powershell ISE in your system.
Santhi Dhanuskodi 325 Reputation points

2023-08-30T08:30:08.75+00:00

With Azure portal - copy option doesnt have the UI/feature to copy from one env to another...this is in latest azure portal....
SSingh-MSFT 16,371 Reputation points Moderator

2023-08-31T08:50:27.42+00:00

Hi Santhi Dhanuskodi •,

Just checking if the provided reply helped. If not, please let us know so that we can further assist you.

Thanks

Answer 1

SSingh-MSFT 16,371 Moderator

Hi Santhi Dhanuskodi •,

Please refer to the steps needed to copy Azure SQL Database from one server to another server as illustrated in the below documentation and video:

https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?view=azuresql&tabs=azure-powershell#copy-to-a-different-server

How to Copy Azure SQL Database to a Different Server |5 Step Process same for Different Subscription

Let us know if this helps or you have further questions.

Thanks

Share via

Copy db from dev to UAT env

1 answer

Your answer