Create a Project By Connecting to a Live Database

Click New Project at the top-right of the Relational Migrator home screen.

Click the Connect database button.

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 a new 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

   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.

4. Enter a Connection name and optional Environment tag.

5. Click Connect.

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

From the Select tables screen, indicate the tables you want to migrate and click Next.

The following table explains the different ways you can select tables to migrate:

Choose a Global casing option for collection names.

This option affects the names of your collections created from the tables in your relational database:

• Keep Original: Keep the original casing used in your relational database table name.

• Override with Global Casing: Override the original table name with a global casing convention.

  • TitleCase

  • camelCase

  • kebab-case

  • snake_case

  • UPPER_SNAKE_CASE

Choose an Initial mappings option for your MongoDB schema.

• Start with a MongoDB schema that matches your relational schema

  Creates your initial project with a new document mapping rule for each table.

• Start with a recommended MongoDB schema

  Relational Migrator creates mapping rules for a suggested MongoDB schema. When you choose this option, a table appears showing the imported relational tables. Relational Migrator suggests which tables should be represented as top-level or embedded collections. You can use the checkboxes to modify which tables are mapped into collections or embedded.

• Start with an empty MongoDB schema

  Creates your initial project with no mapping rules.

Enter a name for your project.

Click Done.