Schema Migration

After resolving errors in your schemas, you can use the schemas with a client application such as pgAdmin, ToadEdge, or PSQL client or migrate the schema to an EDB Cloud Database Service (CDS) cluster.

Please Note: For more information, about using Toad Edge with Advanced Server, see Toad Edge® for Postgres.

The Advanced Server instance must be installed in Oracle Mode to enable native compatibility with key Oracle capabilities.

Migrating a Schema to a CDS cluster

Perform the following steps to migrate your database to a CDS cluster:

  1. On the Assessment page, click Export/Deploy.

  2. Select the Migrate to existing CDS cluster option.

    For information about creating a new cluster, see Creating a Server Cluster.

migration portal image

Migrating database to CDS cluster.

  1. Click Next.
  2. Select the schemas you wish to migrate.
migration portal image

Select schemas for migration.

  1. Click Next to continue.
migration portal image

Provide connection details.

  1. Enter the following details in the Connection Details dialog:
  • Enter the host name or IP address in the Host name/address field.
  • Enter the port number in the Port field.
  • Enter the database name in the Maintenance database field.
  • Enter the user name in the Username field.
  • Enter the password associated with the user in the Password field.
migration portal image

Testing a successful connection.

  1. Click Test Connection to verify the connection details.

    Note: You can click Edit to make changes to the connection details and retest the connection details.

  2. Once the connection is successful, click Deploy.

  3. You can view the deployment details on the Deploy dialog; click Download Summary to download the deployment log.

A successful deployment

A successful deployment.

  1. Click Done to close the window.