Migrating databases to BigAnimal

EDB provides migration tools to bring data from Oracle, PostgresSQL, and EDB Postgres Advanced Server databases into BigAnimal. These tools include Migration Portal and Migration Toolkit for Oracle migrations. More sophisticated migration processes can use tools such as Replication Server for ongoing migrations and LiveCompare for data comparisons.

Migrating from Oracle

The Migration Portal documentation provides the details for executing the migration steps using Migration Portal:

  1. Schema extraction
  2. Schema assessment
  3. Schema migration
  4. Data migration

The Migration Portal documentation describes how to use Migration Toolkit for the data migration step. This toolkit is a good option for smaller databases.

Migrating from Postgres

Several options are available for migrating EDB Postgres Advanced Server and PostgreSQL databases to BigAnimal. One option is to use the Migration Toolkit. Another simple option for many use cases is to import an existing PostgreSQL or EDB Postgres Advanced Server database BigAnimal. See Importing an existing Postgres database.