AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관
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

주제
마이그레이션 및 현대화데이터베이스분석
태그
AWS 데이터베이스 마이그레이션 서비스마이크로소프트 SQL 서버PostgreSQL아마존 Relational Database Service
언어
English
Olive
질문됨 한 달 전291회 조회
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
Manish Bhasin
답변함 한 달 전
  • Olive
    한 달 전

    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

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠