Ultimate Script to complete PostgreSQL-to-PostgreSQL Migration right after AWS DMS task done

Sequence, Foreign key, Index, and Constraint are available for migration.

1. Sequence, Foreign key, Index, and Constraint are not migrated using AWS DMS.
2. You must need them if you want to promote the target DB as primary.
3. This script is responsible for completing a migration by putting them into your target DB.

git clone https://github.com/sinwoobang/dms-psql-post-data.git
npm -i g zx

1. Run sequences_generator.sql on your source DB.
2. Copy the result and run it on the target DB.

1. Copy a template file

cp info-template.js info.js

2. Revise info.js
3. zx index_constraint_migration.mjs