Manage the Relational Model
On this page
You can use the Manage button on the Schema model pane to make changes to the schemas or tables you want to include in your migration project. You can also connect to the source database or use a DDL file to refresh the list of available tables.
Add or Remove Tables from a Project
To change the tables you're migrating from your relational database, use the Manage button.
From the Mapping screen, click the Manage button on the Schema model pane.
Click the check box next to the schema or schemas you are migrating.
To expand the tables in a schema, click the button.
Select the tables you want to add or remove from your migration.
Click Save.
Changes from your relational database are reflected in the main Relational Migrator diagram and included in future sync jobs.
Refresh Schema Changes
If your relational database table structure changes, use the Refresh Schema button to let Relational Migrator know.
From the Mapping screen, click the Manage button on the Schema model pane.
Click the Refresh schema button on the Manage relational model modal.
Select either Connect to database or Import DDL File.
Connect to database
Connect to database rescans the schema. Changes in foreign key relations or data types for the underlying tables are read into Migrator.
Input the JDBC URI, Username and Password for the database instance you are connecting to.
The account used can be different from the credentials you used when creating the project.
Note
Relational Migrator remembers the MongoDB URI and the username but not the password. When you refresh the schema, re-enter the password.
Click Connect.
Click Save.
Any changes from your relational database are reflected in the main Relational Migrator diagram and included in future sync jobs.
Import DDL File
Import DDL File opens a file prompt that accepts a DDL file of the relational schema you are migrating. Any changes in the foreign key relations or data types for the underlying tables are read into Migrator.
Select your Database type.
Relational Migrator currently supports the following database types:
MySQL
Oracle
PostgreSQL
SQL Server
Choose a file or drag and drop a DDL statement file.
Click Import.
Click Save.
Any changes from your relational database are reflected in the main Relational Migrator diagram and included in future sync jobs.