Azure DMS error (AWS RDS SQL Server to Azure SQL MI)

Question

Azure DMS error (AWS RDS SQL Server to Azure SQL MI)

Amrita Visalam 26

We are trying to migrate our AWS RDS SQL Server DB to Azure SQL MI using Azure DMS. We have provisioned our DMS and have created a migration project: ![206009-dmsintro.png][1] While trying to connect to our AWS RDS SQL Server, we are getting the following issue: ![206059-image.png][2] [1]: /api/attachments/206009-dmsintro.png?platform=QnA [2]: /api/attachments/206059-image.png?platform=QnA Notes: 1. The error is shown instantly, as if it isn't even trying to connect to the server. 2. We are able to telnet to the RDS server Does anyone know why this is happening?

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Vidhya Sagar Karthikeyan 396

anonymous user

Looks like migration from AWS RDS to Azure MI is not supported. Currently, AWS RDS to Azure SQL is supported but not to SQL MI.

From the blog

When it comes to migrating RDS for SQL databases, we cannot use DMA or Log Replay Service methods because RDS SQL Server takes backups without checksum enabled and both of these methods require backups to have the checksum enabled in order to verify the consistency at the restore time.

Please mark the post as answer if this helps

Amrita Visalam 26 Reputation points

2022-06-14T13:36:06.037+00:00

Thank you,
The Azure DMS team should probably update the documentation (https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql#create-an-azure-database-migration-service-instance) and portal where they mention Azure SQL MI as a target for AWS RDS for SQL Server. Seems unwise to have misinformation on the official documentation.
Vidhya Sagar Karthikeyan 396 Reputation points

2022-06-20T10:44:55.31+00:00

Agreed anonymous user, The documentation is not clear as well as the error message returned from the DMS also is generic and didn't give the clear details to the user. Let me see if I can raise feedback for these two, atleast it will be helpful for future.

Thanks for accepting my response as an answer

Answer 2

GeethaThatipatri-MSFT 29,582 Microsoft Employee Moderator

Hi, anonymous user Welcome to Microsoft Q&A, Thanks for posting your query.
SQL to SQL MI leverages log shipping as a mechanism for migration. This won’t work for RDS SQL.
One of the ways that you can do work around this is to treat SQL MI as an SQL DB endpoint.
When creating a project, select RDS SQL -> Azure SQL DB. This will still allow you to connect to SQL MI on the target side … Which will allow an offline migration.
Please let us know if that works?

Regards
Geetha

GeethaThatipatri-MSFT 29,582 Reputation points Microsoft Employee Moderator

2022-06-03T03:55:36.383+00:00

Hi, anonymous user Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Please let us know if you need any additional information.

Regards
Geetha

Share via

Azure DMS error (AWS RDS SQL Server to Azure SQL MI)

1 additional answer

Your answer