AWS DMS Resolving 'Failed to Retrieve Capture List' Error in MSSQL to MySQL Migration

0

Hi Team,

I have an MSSQL database on Microsoft Azure, and I'm planning to migrate data from one table to an AWS EC2 instance running MySQL. However, when I execute the migration task, I encounter the following error:

**

Last Error: Failed to retrieve the capture list from the endpoint. Stop Reason: FATAL_ERROR Error Level: FATAL

**

Could someone please guide me on resolving this issue? Additionally, I'd appreciate instructions on how to successfully migrate a single table from MSSQL to MySQL.

Thanks, Krishnakumar K

1 個回答
0

Hello.

This error usually indicates an issue with the source endpoint configuration or network connectivity between AWS DMS and the source database.

Check Endpoint Configuration: Ensure that the source endpoint for the MSSQL database is correctly configured in AWS DMS. Verify the connection details like server name, port, and credentials. Confirm that the specified database user has the required permissions to read the database objects.

Network Connectivity: Check if the AWS DMS instance can reach the MSSQL database hosted on Azure. Verify that there are no network issues like firewalls or security groups blocking the connection.

Regards, Andrii

profile picture
專家
已回答 6 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南