Migration of Multiple databases from one managed instance to another managed instance

Question

Hello Team,

I have a requirement to migrated multiple databases ( count of 50s) from one SQL MI instance to another.

Is there a simple way to do that.

I know copy option of Managed instance but that is on database level. i need to repeat for every database.

Any help over here will be helpful.

Answer 1

I just seen in portal. Now, we have option to select multiple database while copying over to another instance.

that solves my query.

Posting here, so that others can benefit also.

multiple copy at one go.JPG

Answer 2

Thanks for your question.

You can use Azure CLI or PowerShell to automate the migration process.

With automation tools like the PowerShell - Azure DataMigration Service Module or Azure CLI, you can apply the capabilities of the Azure SQL Migration extension together with Azure Database Migration Service to migrate one or more databases at scale (including databases across multiple SQL Server instances).

Here is a reference document https://learn.microsoft.com/en-us/azure/dms/migration-dms-powershell-cli

Another method would be, migrate SQL Server to SQL Managed Instance offline with PowerShell & Azure Database Migration Service

https://learn.microsoft.com/en-us/azure/dms/howto-sql-server-to-azure-sql-managed-instance-powershell-offline

You can also use the backup and restore approach to migrate your databases. With the help of the job, you can take a backup of all the databases from the source SQL MI instance and then restore them to the target SQL MI instance.

Yes, the copy is another method which you already aware.

Whichever approach you choose, please make sure to thoroughly test the migration process.

Thanks!

Answer 3

Hi @Chetan Jain
While it's great feedback, I don't think there is a more convenient way other than scripting the operations.

You can run multiple database copies and move operations from the source-managed instance to one or more target instances.

Note that the source instance can run up to eight copy or move operations at a time. You can start more than eight operations, but some will be queued and processed later, as managed by the service.

See Managed Databases - Start Move - REST API (Azure SQL Database) | Microsoft Learn

Managed Databases - Complete Move - REST API (Azure SQL Database) | Microsoft Learn

I hope this information helps, please let me know if you have any additional questions.

Regards

Geetha