AWS DMS migration task doesn't automatically increment the source table
0
I'm trying to perform a basic AWS DMS migration of Amazon RDS MySQL to Amazon Aurora MySQL. The data from the source table has been successfully copied, and I performed an alter table on the database, which auto incremented the primary key. However, whenever data was inserted in to the database, the target hadn't been updated. Is there any configuration within the data replication task that will allow me to do this? Or is this something that needs to be done manually?
Sprache
English
gefragt vor 4 Jahren1841 Aufrufe
1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
0
It isn't recommended to use AWS DMS or mysqldump to transfer a schema. This approach can cause issues such as the one you're experiencing, where a column marked as auto_increment did not transfer over successfully.
beantwortet vor 4 Jahren
Relevanter Inhalt
AWS OFFICIALAktualisiert vor 2 Jahren- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 3 Jahren