1 Answer
- Newest
- Most votes
- Most comments
0
Please note that DMS only migrates data carrying objects table data with atleast pk or unique key. If you are migrating from same engine, you can script out the table definition and apply the same at target before migrating the data with DMS. Also not you need to make sure DMS task setting target table preparation mode is set to truncate_only and not drop and recreate tables.
If you are using different database engines you can use Schema Conversion Tool to convert and apply table definition https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html
Please note sct would also help with secondary indexes, foreign keys, stored procedures functions triggers etc.
answered 21 days ago
Relevant content
- asked 2 years ago
- asked 5 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 8 months ago