Migrating databases to Cloud Service

Suggest edits

EDB provides migration tools to bring data from Oracle, PostgresSQL, and EDB Postgres Advanced Server databases into Cloud Service. 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 Cloud Service

Cloud Service 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 Cloud Service 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 Cloud Service. 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 Cloud Service. 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.

Importing an existing Postgres database

Bulk loading data into PGD clusters

This guidance is specifically for environments where there's no direct access to the PGD nodes, only PGD Proxy endpoints, such as Cloud Service's distributed high availability deployments of PGD.

← Prev

Performing a major version upgrade of Postgres on Cloud Service

↑ Up

Managing your cluster

Next →

Importing an existing Postgres database

Could this page be better? Report a problem or suggest an addition!