AWS DMS Migration Completed Successfully but No Inserts in Target PostgreSQL Database

0

I recently completed a migration using AWS Database Migration Service (DMS) from a source MSSQL DB on RDS to a target PostgreSQL DB on RDS. The full load process completed successfully, but I noticed that there are no inserts in the target database. The postgres db tables are empty. I've checked the source tables, replication task settings, and DMS logs, but I'm unable to identify the cause of the issue. Has anyone encountered a similar issue during their DMS migrations, and if so, please how did you troubleshoot and resolve it?

dms mappping rules

1 個回答
0

Hello

Please follow this repost article to enable the detailed debug to identify the insert sql and it's action

How do I set up detailed debug logging for my AWS DMS task?

AWS
已回答 1 個月前
  • I have that set up

    No records received to load or apply on target , waiting for data from upstream.

    • this is the most detail I got but why, as the source db has data and it fails to insert the data to the target db is what I want to know and resolve

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

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

回答問題指南