dms-psql-post-data
Ultimate Script to complete PostgreSQL-to-PostgreSQL Migration right after AWS DMS task done
TL;DR
Sequence, Foreign key, Index, and Constraint are available for migration.
Why You Need It
- Sequence, Foreign key, Index, and Constraint are not migrated using AWS DMS.
- You must need them if you want to promote the target DB as primary.
- This script is responsible for completing a migration by putting them into your target DB.
How to Run
Migrating Sequence
- Run sequences_generator.sql on your source DB.
- Copy the result and run it on the target DB.
Migrating Index & Constraint
- npm i -g zx
- zx index_constraint_migration.mjs
- Input required data
