Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
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

Temas
Migración y modernizaciónBase de datosAnálisis
Etiquetas
Servicio de AWS Database MigrationMicrosoft SQL ServerPostgreSQLAmazon Relational Database Service
Idioma
English
Olive
preguntada hace un mes265 visualizaciones
1 Respuesta
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
respondido hace un mes
  • Olive
    hace un mes

    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

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante