By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

Topics
Migration & ModernizationDatabaseAnalytics
Tags
AWS Database Migration ServiceMicrosoft SQL ServerPostgreSQLAmazon Relational Database Service
Language
English
Olive
asked 13 days ago208 views
1 Answer
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
Manish Bhasin
answered 13 days ago
  • Olive
    12 days ago

    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

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content