2 Using Migration Toolkit

Table of Contents Previous Next


2 Using Migration Toolkit

Migration Toolkit is a powerful command-line tool that offers granular control of the migration process. Migration Toolkit can migrate immediately and directly into a Postgres database (online migration), or you can also choose to generate scripts to use at a later time to recreate object definitions in a Postgres database (offline migration).
By default, Migration Toolkit performs an online migration, creating data and database objects directly into a Postgres database. If you include the -offlineMigration option when invoking Migration Toolkit, Migration Toolkit will generate SQL scripts to reproduce the migrated objects or data in a new database. You can alter the migrated objects by customizing the migration scripts generated by Migration Toolkit before you execute them, or schedule the actual migration for a time that best suits your work load.
If you are only migrating schema objects to a cluster, and use an ssh tunnel (with compression enabled), online migration of database object definitions may be a viable option. If you are migrating large amounts of data, network overhead may make an online migration prohibitively slow; Migration Toolkit's ‑offlineMigration option might provide a better migration path.

2 Using Migration Toolkit

Table of Contents Previous Next