Target Connection

This step involves specifying the target PostgreSQL database into which the migration results will be written.

Similar to the source connection, the connection string for the target database must adhere to the following format [postgres://]host[:port]/database_name[?parameter=value]

protocol optional string

Declares the DBMS. Allowed values: postgres

Default: postgres

host required string

The hostname or IP address of the target database. Ensure that the CYBERTEC Migrator can access this machine.

Default: none

port optional int

The port on which the target database is accessible.

Default: 5432

database_name required string

The name of the database within your cluster.

Default: none

parameter optional string

Optional connection parameters. Multiple parameters may be split with &.

The following parameters are currently supported:

• application_name
• connect_timeout
• keepalives
• sslmode

Default: none

127.0.0.1/postgres
localhost:5432/my_db?application_name=my_app
postgres://localhost/my_database?connect_timeout=10
example.org/my_database?sslmode=require&keepalives=1

The credentials to be used with the connection string.

After entering all the required information, submit the form to confirm that the CYBERTEC Migrator can establish a connection.

In case no connection can be established, or you simply want to introspect the source data schema, this step may be skipped by clicking the Continue anyways button.

After configuring the target connection, the migration creation concludes with the Analyze step.