PostgreSQL Software:Migration Toolkit
A feature-rich command-line tool to migrate tables and data from your DBMS to PostgreSQL or EDB Postgres Advanced Server.
The migration from your existing RDBMS to Postgres or to EDB Postgres Advanced Server requires data and structures to be recreated in the target environment.
When such a migration gets serious, you need a box of the right tools. Powerful, configurable and scriptable to do off-line or on-line work to get you to the finish line.
Online and offline migration
Migrate immediately and directly into a Postgres database (online migration), or generate scripts to use at a later time to recreate object definitions (offline migration)
Granular migration control
Control and specify batch size, change column data types, commit row by row and bypass WAL logging to optimize migration, filter only rows that meet specific criteria
Specify a wide variety of options to instruct the Migration Toolkit to execute the migration to the specific demands of your project
The Migration Toolkit
The Migration Toolkit is at the core of any migration effort of scale. As soon as your project gets a little more demanding, trying and testing migration scenarios is very important. From data to structure, repeatability and configurability of such a process, helps prepare for a quick, smooth and faultfree migration at go-live. The Migration Toolkit gives you the ability to do just that.