• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

Data operations options

While performing data operations (comparison, synchronization, migration and detailed comparison), you get to the Data comparison options, Data synchronization options or Data migration options pages. Here you can manage table options, data options (see the particular pages of the manual) and change relevant options for each pair of data objects. Please note that the settings vary depending on the chosen operation type.

  1. In the left side of Options window you can see the objects tree of matched object items (tables, views and columns).

    Modified options are located in the right side of the window, and they are relevant to the chosen node of the objects tree.

    Please note that changing settings in the Default Options node (at the top of the objects tree) will affect all pairs of data objects in current operation.

  2. You can change options for the desired pair of data objects. To do so, select them from the objects tree in the left side of the window.

    • Please note that the names of the selected objects are bold, as well as the names of their parent objects.

    • Available for modification options will be shown at the right side. If there are no options available for modification for the selected pair, you will get the corresponding message.

  3. In the Data comparison mode, you can modify the following table options at the top of the right side:

    • Check the Expand Foreign Keys option to join the primary table with all referenced tables. The data comparison operation will use the data of summary table (which consists of primary and referenced tables).
      Uncheck the Expand Foreign Keys option to compare data only in the primary table.

    • Check the Exclude LOBs option to exclude large data objects from the comparison operation. If the Exclude LOBs option is unchecked, all objects will be compared and the run time of the operation will sufficiently increase.

  4. In the Data comparison mode, you can modify the same table settings as described in items 2a and 2b. Additionally, the following options are available in the right panel:

    • Check the Show Ignored Columns option in the Data display options panel to display columns that are not used in comparison.

    • Check the Show Equal Rows option in the Data display options panel to display equal rows in comparison results.

    • Enter custom filters (SQL queries to be applied when data is retrieved) for the left and right tables in the appropriate fields in the Custom filter queries panel.

  5. In the Data comparison mode, you can treat empty values as NULL. To do so, select an option Treat empty as null in the common options for data types at the bottom of the options list.

  6. In the Data synchronization mode, you can modify the following table options at the top of the right side:

    • Check the Enable delete option to allow deleting data in target table during Data synchronization operation.

    • Check the Keep identity option to preserve source identity values. Uncheck the Keep identity option to assign the identity values by the target object.

    • Check the Fire triggers option to fire insert triggers for the rows which are being inserted into the target database.

    • Check the Check constraints option to enable constraints checking when data is being inserted into the target database.

    • Check the Exclude LOBs option to exclude large data objects from the synchronization operation. If the Exclude LOBs option is unchecked the run time of the operation will sufficiently increase.

  7. In the Data migration mode, you can modify the following table options at the top of the right side:

    • Check the Truncate target table option to truncate the target table before migration.

    • Check the Keep NULLs option to preserve null values in the target table regardless of the settings for default values.

    • Check the Lock target table option to apply a table-level lock to the target table. The lock will be applied during the data migration operation.

    • Check the Keep identity option to preserve source identity values. Uncheck the Keep identity option to assign the identity values by the target object.

    • >Check the Fire triggers option to fire insert triggers for the rows which are being inserted into the target database.

    • Check the Check constraints option to enable constraints checking when data is being inserted into the target database.

    • Check the Exclude LOBs option to exclude large data objects from the synchronization operation. If the Exclude LOBs option is unchecked the run time of the operation will sufficiently increase.

    • Specify the Batch Size in the appropriate data field. When the specified batch rows limit is reached, the data is sent to server.

  8. For Data options management, please see the corresponding pages of this manual.

  9. Click the Reset button to restore default parameters for all modified options.