patternsqlModerate
AWS DMS creates tables with no auto_increment
Viewed 0 times
tablescreatesauto_incrementwithdmsaws
Problem
I am migrating my databases to Amazon's RDS using their DMS tool. Pretty much everything looks great except that columns that were marked as auto_increment on the source database did not get marked as auto_increment on the target database. I also noticed that my indexes and foreign key constraints were not included. I am running version 5.6 on both ends.
Is there a way to get DMS to include the full create tables for my database?
Is there a way to get DMS to include the full create tables for my database?
Solution
If DMS is told to create the table on the destination (the default option) it only creates the most basic structure needed to move the raw data over. So you shouldn't trust that other metadata like default values are moved over either.
You can either migrate all your changes after moving the data, or create the schema first on your destination and tell DMS not to create tables.
Just keep in mind that copying data with indexes at the same time is much slower, so if you have a lot of data you can create them afterwards or simply just wait longer for the sync.
You can either migrate all your changes after moving the data, or create the schema first on your destination and tell DMS not to create tables.
Just keep in mind that copying data with indexes at the same time is much slower, so if you have a lot of data you can create them afterwards or simply just wait longer for the sync.
Context
StackExchange Database Administrators Q#138946, answer score: 10
Revisions (0)
No revisions yet.