Move Azure SQL Database

Question

Move Azure SQL Database

Handian Sudianto 6,001

Hello,

How we can move SQL DB from one Azure SQL server to another Azure SQL Server?

Aswin 472 Reputation points

2023-12-28T02:34:27.5066667+00:00

You can copy the database from one Azure SQL server to other SQL server using Azure portal, powershell, CLI or even through T-SQL. Refer the MS document to do this. If you want database to be moved and not to be copied, then you can delete the database in source server once it is copied to destination server.

Accepted answer

0 additional answers

Your answer

Aswin 472 Reputation points

2023-12-28T02:34:27.5066667+00:00

You can copy the database from one Azure SQL server to other SQL server using Azure portal, powershell, CLI or even through T-SQL. Refer the MS document to do this. If you want database to be moved and not to be copied, then you can delete the database in source server once it is copied to destination server.

Answer 1

Hey,
Similar thread :

https://stackoverflow.com/questions/24028958/copy-sql-azure-database-to-different-server

There is no way to directly move the database from 1 server to another.

You need to copy /clone the db from 1 server to another and then delete the original one.

To copy the database, there are multiple ways
User's image

Powershell :

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

Additional details :

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

Share via

Move Azure SQL Database

0 additional answers

Your answer