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

For helpful considerations and information when migrating from Oracle, review the EDB Migration Handbook.

EDB also provides a tool, Migration Portal, which provides the details for executing the migration steps:

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

You can also use the Migration Toolkit for the data migration step. This toolkit is a good option for smaller databases.

Accessing remote Oracle servers from BigAnimal

BigAnimal supports the edb_dblink_oci extension and a set of dblink_ora functions, which you can use to create Oracle syntax-compatible database links and include calls to functions that are only available in Oracle, respectively.

See the following BigAnimal knowlege base articles for step-by-step instructions for creating links to remote Oracle servers from EDB Postgres Advanced Server clusters:

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 to BigAnimal. See Importing an existing Postgres database.

Migrating to distributed high availability clusters

When migrating to a PGD-powered distributed high availability (DHA) cluster, we recommend that you follow the instructions in DHA/PGD bulk migration. This content provides a step-by-step process for migrating your data to a DHA cluster while minimizing the impact of subsequent replication on the process.