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.
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:
You can also use the Migration Toolkit for the data migration step. This toolkit is a good option for smaller databases.
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:
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.