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 to apply your table selections to the project.

   The main Relational Migrator diagram reflects changes from your relational database. Future migration jobs include these changes.

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:

      OracleSQL ServerMySQLPostgreSQL

      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.

   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.