- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
Hello, From the provided description you are running in to a Duplicate key error. Below are some suggestions that can be followed to mitigate the issue. When the task is in Full Load please disable foreign keys and triggers on the target table. For Full Load remove the Auto Increment property on the table and add it after the full load is done with a maximum value for the column by resetting it.
[+] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html#CHAP_Source.MySQL.Limitations [+] https://aws.amazon.com/blogs/database/debugging-your-aws-dms-migrations-what-to-do-when-things-go-wrong-part-1/ [+] https://aws.amazon.com/blogs/database/debugging-your-aws-dms-migrations-what-to-do-when-things-go-wrong-part-2/ [+] https://aws.amazon.com/blogs/database/debugging-your-aws-dms-migrations-what-to-do-when-things-go-wrong-part-3/
Contenuto pertinente
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata 2 anni fa