Manage the Relational Model

Add or Remove Tables from a Project

To change the tables you're migrating from your relational database, use the Manage button.

1. From the Mapping screen, click the Manage button on the Schema model pane.

2. Click the check box next to the schema or schemas you are migrating.

3. To expand the tables in a schema, click the button.

   Select the tables you want to add or remove from your migration.

4. Click Save.

   Changes from your relational database are reflected in the main Relational Migrator diagram and included in future migration jobs.

Refresh Schema Changes

If your relational database table structure changes, use the Refresh Schema button to let Relational Migrator know.

1. From the Mapping screen, click the Manage button on the Schema model pane.

2. To refresh the schema for the active Relational DB connection, click the Refresh schema button on the Manage relational model modal.

3. To refresh the schema for a file, click Import DDL File

Change Databases

You can change the active Relational DB in the Database Connections bar, such as switching the connection from a staging database to one in production. This re-scans the schema. Migrator reads in any changes in foreign key relations or data types for underlying tables.

1. Click the Relational DB drop-down.

   To use a saved relational database connection, click Use a saved connection and select it from the drop-down, then enter credentials if required.

   To create a new connection, click + Add Connection:

   1. In the Database type drop-down, select the database type.

   2. To enter a connection string directly, enable the Enter URI manually toggle and paste your connection string into the JDBC URI.

   3. To create a connection string by entering database information, enter the following:

      Oracle

      SQL Server

      MySQL

      PostgreSQL

      DB2

      Sybase ASE

      Field	Value
      Host	The host IP or DNS name.
      Port	The port number.
      Database	The database name. Required.
      Identifier	One of Service Name or SID.
      Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.

      Field	Value
      Host	The host IP or DNS name.
      Port	The port number.
      Database	The database name. If blank, you only see objects in the default dbo schema in all databases.
      Authentication	By default, this is set to SQL Server. Set to Windows to enable Windows Integrated Authentication, using the credentials of the user who launched the Relational Migrator executable. This disables the Username and Password fields.
      Username and Password	The credentials to use for authentication. Disabled if Authentication is set to Windows. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.
      General / SSL toggle	View SSL settings for the connection. To use SSL, you must first uncomment and update the server.ssl configuration properties in your user.properties file.
      SSL: Use SSL	Enable or disable SSL.
      SSL: Trust server certificate	With SSL enabled, check this to trust the stored certificate. Leave unchecked to verify the server certificate against a trusted Certificate Authority.

      Field	Value
      Host	The host IP or DNS name.
      Port	The port number.
      Database	The database name. Leave blank to load all databases.
      Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.
      General / SSL toggle	View SSL settings for the connection. To use SSL, you must first uncomment and update the server.ssl configuration properties in your user.properties file.
      SSL: Use SSL	Enable or disable SSL.
      SSL: SSL mode	With SSL enabled, choose from: Preferred (default): Make an encrypted connection if possible, otherwise fall back to an unencrypted connection. Required: Require an encrypted connection. Verify CA: Verify the server certificate against a trusted Certificate Authority. Verify identity: Verify the database connection information against the certificate contents.

      Field	Value
      Host	The host IP or DNS name.
      Port	The port number.
      Database	The database name. Leave blank to connect to the default database.
      Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.
      General / SSL toggle	View SSL settings for the connection. To use SSL, you must first uncomment and update the server.ssl configuration properties in your user.properties file.
      SSL: Use SSL	Enable or disable SSL.
      SSL: SSL mode	With SSL enabled, choose from: Prefer (default): Make an encrypted connection if possible, otherwise fall back to an unencrypted connection. Require: Require an encrypted connection. Verify CA: Verify the server certificate against a trusted Certificate Authority. Verify full: Verify the database connection information against the certificate contents.

      Field	Value
      Host	The host IP or DNS name.
      Port	The port number.
      Database	The database name. Required.
      Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.

      Field	Value
      Host	The host IP or DNS name.
      Port	The port number.
      Database	The database name. Leave blank to connect to the default database.
      Username and Password	The credentials to use for authentication. Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.

   4. Enter a Connection name and optional Environment tag.

   5. Click Connect.

      The saved connection is available for use in all jobs and projects.

Any changes from your relational database are reflected in the main Relational Migrator diagram and included in future migration jobs.