Create Mapping Rules

Open a Relational Migrator project.

Open the Mappings pane.

You can do this from the Schema model pane by clicking on a collection under the Relational or MongoDB headers.

Click + Add to create a new mapping rule.

If you opened this pane from the Relational header, this button is next to Mappings to MongoDB Model. If you opened the pane from the MongoDB header, this button is next to Mappings from relational tables.

Define how you want to migrate the source table.

Options available on the Add mapping pane depend on the type of mapping rule you are adding. For a full overview of each mapping rule option see:

• New Documents

• Embedded Array

• Embedded Documents

Select the name of the source table or target collection.

If you opened this pane from the Relational header, input the name of the target collection. If you opened the pane from the MongoDB header, select the name of the source table from the drop-down menu.

Define options for the new mapping rule.

When you define the mapping rule, you can:

• Change the collection name.

  To change the collection name, click the Name text box and enter the new name. Click outside of the text box to save the change. If the name is already in use, you receive a validation error.

• Change field names.

• Include or exclude a field from your migration job by clicking the icon next to the field name.

(Optional) Select a BSON type or set null handling rules for your mapping rule.

1. Click the icon next to the field you want to customize.

2. Select a BSON type.

3. Select a Null handling option.

   • Insert as null: preserves null values, and nulls are inserted into your destination collection.

   • Omit: skips any null values, and nulls are not inserted into the destination collection.

You can view a field's Original name and Original type in the expanded customized field menu.

Click Save and close.