Schema migration

After resolving errors in your schemas, you can use the schemas with a client application such as pgAdmin, Toad Edge, or the PSQL client. Or you can migrate the schema to an EDB Postgres Advanced Server.

You can migrate to any of these schemas:

  • Existing on-premises EDB Postgres Advanced Server

  • New on-premises EDB Postgres Advanced Server

  • EDB Postgres Advanced Server in the cloud

Migrating to an existing on-premises EDB Postgres Advanced Server host

You can migrate schemas to an existing on-premises EDB Postgres Advanced Server on Windows or Linux platforms.

Migrate schemas on Windows

  1. Select Existingon-premisesEDBPostgresPostgresAdvancedServer .

  2. Select one or more schemas to migrate to EDB Postgres Advanced Server.

Note

If your schemas aren’t 100% compatible, a banner appears. Complete the Contact Us form as needed.

  1. To download the assessed schemas, select DownloadSQLfile .

  2. Select Windows .

  3. To import the schemas, run:

  • On CLI:

\i c:\users\...\<project_name>.sql

  • On cmd/shell:

edb-psql -f <project_name>.sql

Note

You can alternatively use the pgAdmin client for the import.

The converted schemas migrate to the target server.

Migrate schemas on Linux

You can migrate schemas to an existing on-premises EDB Postgres Advanced Server on Linux.

  1. Select Existingon-premisesEDBPostgresAdvancedServer .

  2. Select one or more schemas to migrate to EDB Postgres Advanced Server.

  3. To download the assessed schemas, select DownloadSQLfile .

  4. Select Linux .

  5. To import the schemas, invoke the following edb-psql client commands:

sudo su - enterprisedb
edb-psql edb
create database <database_name>;
\connect <database_name>
\i <project_name>.sql

Note

You can alternatively use the pgAdmin client for the import.

The converted schemas migrate to the target server.

Migrating to a new on-premises EDB Postgres Advanced Server installation

You can install new EDB Postgres Advanced Server on premises on Windows or Linux platforms and migrate the schemas.

Migrate schemas on Windows

Migrate schemas to a new on-premises EDB Postgres Advanced Server on Windows.

  1. Select Newon-premisesEDBPostgresPostgresAdvancedServer .

  2. Select one or more schemas to migrate on EDB Postgres Advanced Server.

  3. For the operating system, select Windows .

  4. Select DownloadWindowsinstaller .

  5. For installation steps, select EDBPostgresAdvancedServerInstallationGuideforWindows .

  6. To download the assessed schemas, select DownloadSQLfile .

  7. You can import schemas by running:

  • On CLI

\i c:\users\...\<project_name>.sql

  • On cmd/shell

edb-psql -f <project_name>.sql

Note

You can alternatively use the pgAdmin client for the import.

Migrate schemas on Linux

Migrate schemas to an on-premises EDB Postgres Advanced Server on Linux.

  1. Select NewOn-premisesEDBPostgresAdvancedServer .

  2. Select one or more schemas to migrate on EDB Postgres Advanced Server.

  3. For the operating system, select Linux .

  4. You can select one of the following options to install the EDB Postgres Advanced Server:

  • Repository - More options

  1. For information on the installation procedure, select EDBPostgresAdvancedServerInstallationGuide for Linux.

  2. To download the assessed schemas, select DownloadSQLfile .

  3. To import the schemas, run:

sudo su - enterprisedb
edb-psql edb
create database <database_name>;
\connect <database_name>
\i <project_name>.sql

Note

You can alternatively use the pgAdmin client for the import.

The converted schemas migrate to the target server.

Migrate to the cloud

Migrate schemas on EDB Postgres Advanced Server to the cloud.

  1. Select EDBPostgresAdvancedServeronCloud .

  2. Select one or more schemas to migrate to EDB Postgres Advanced Server.

  3. Select the cloud platform, for example, BigAnimal .

  4. To launch a new cluster, select GotoBigAnimal . Or, if you have an existing cluster running, select Next .

Note

See the Big Animal page for more information.

  1. Enter the required connection details on the Connect page.

Connecting to the cloud cluster

Connecting to the cloud cluster

  1. To verify the connection details, select TestConnection .

Note

You can select Edit Connection to make changes to the connection details and retest the connection details.

  1. Once the connection is successful, select Next .

The converted schemas migrate to the target server.