Migration to azure sql vm using Azure Data Studio

SaikrishnaE 51

I have two instances on my SQL Server(MSSQL and SQL2019), named and default instances. i wanted to migrate them to Azure SQL VM which has two instances. How can i migrate them using Azure Data Studio, specific to an instance, say source Default instance to Target Default instance, and Named Instance from source to the Named Instance on Target

1 answer

YufeiShao-msft 7,056 Reputation points

2022-08-23T03:24:32.497+00:00

Hi @SaikrishnaE ,

Please check out this doc:
Migration overview: SQL Server to SQL Server on Azure VMs

Migrate databases with Azure SQL migration extension for Azure Data Studio

In Azure Data Studio, DMS is one of the core components in the overall architecture, but you need pay attention to overwriting existing databases using DMS in your target SQL Server on Azure VM is not supported.

If allowed, you can also choose to backup and restore, it can attach the database from SSMS in your Azure VM

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
YufeiShao-msft 7,056 Reputation points

2022-08-24T01:16:49.64+00:00

If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.

Regards

YufeiShao-msft 7,056 Reputation points

2022-08-25T08:40:22.537+00:00

Please do not forget to mark as accepted answer wherever information provided to you were helpful.

Regards

SaikrishnaE 51 Reputation points

2022-08-25T08:44:59.437+00:00

Hi @YufeiShao-msft thanks for responding to my question, so when iam trying to restore my databases to the named instance on my target sql vm, it is not restoring on the named instance, by default it is restoring on the default instance. can we migrate to named instance using Azure Data studio?

YufeiShao-msft 7,056 Reputation points

2022-08-31T02:01:19.19+00:00

You can migrate to named instance using Azure Data studio, and the same time, run database assessment will help you avoid many issues

Sandeep Sobti 21 Reputation points

2022-11-21T14:51:22.773+00:00

I am also facing similar issue while migrating the databases to the named instance. We have configured 4 named instances along with the default instance on the target Azure SQL VM. But, Azure Data Studio Migration Extension doesn't even detect any of the named instance on the "Azure SQL Target" screen. It eventually restores in the default instance on the target even if we type in the named instance name manually. Is it a limitation of the Migration extension?

SaikrishnaE 51 Reputation points

2022-11-23T10:48:35.31+00:00

@Sandeep Sobti after my research, yes, that was the limitation when we migrate using Azure Data Studio target as Azure SQL VM. It only detects the Default SQL instance. Also, if we have multiple default instances in the same server, it will pick the Default instance with the highest SQL server version
Sign in to comment