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

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ