Docs Menu
Docs Home
/
Relational Migrator
/

Edit Rules

On this page

  • About this Task
  • Steps
  • Learn More

You can update a mapping rule after it is created. Edited mapping rules take effect the next time a sync job is run.

Options available on the edit pane depend on the type of mapping rule you are editing. For an overview of each mapping rule option, see:

  • New Documents

  • Embedded Array

  • Embedded Documents

  1. From the Mapping screen, click a table or collection name on the Schema model pane or Diagram view.

  2. From the Mappings pane, click the icon.

  3. Define the options for the mapping rule. When defining the mapping rule, you can:

    • Change the collection name.

    • Change field names.

    • To include or exclude a field from your sync job, click the icon next to the field name.

  4. Optionally, if you want to 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.

    Note

    For additional details on field customization and data type conversions, see field customizations.

  5. Click Save and close to save your edits.

To learn more about managing mapping rules, see:

Back

View Rules