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?
asked 2 years ago121 views
1 Answers
0
Accepted Answer
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.
answered 2 years ago
Relevant questions
DMS service for aurora postgres doesnt accept a view as source for full load process
asked 3 months agoAWS DMS Duplicate entry error
asked 11 days agoDo source filters speed up DMS from AWS RDS to S3?
asked 6 months agoDoes AWS DMS has any way to touch or modify source tables?
asked a month agoMigrate MySQL 8 to Aurora MySQL 8
asked 4 months agoDMS - How to retain non-ASCII values when running DMS task from MySQL source to Redshift target
asked 3 months agoDMS service for hive table migration
Accepted Answerasked 2 years agoDMS Migration MongoDB source and RDS Postgres as destination
Accepted Answerasked 20 days agoAWS DMS migration task doesn't automatically increment the source table
Accepted Answerasked 2 years agoDoes AWS DMS support ARRAY data type for RDS for PostgreSQL on EC2 to Aurora PostgreSQL migration?
Accepted Answerasked 2 years ago