• 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. On the left side of Options window you can see the objects tree of matched object items (tables, views and columns). The application highlights in bold the pairs object and their parent nodes if the set of preferences for this pair differs from the default set of preferences.

    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.

    The Warning icon indicates that the selected pair of data objects has no matched columns. Usually, there are no columns with identical names. Such pairs will be excluded from the operation. If you want to match columns manually, you should return back to previous page.

  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.

  3. 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.

  4. In the Data comparison mode, you can modify the following data object options at the top of the right side:

    • 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.

    • Check the Exclude computed columns option to exclude computed options from the comparison operation. If the Exclude computed columns option is unchecked, all objects will be compared.

    • Check the Disable progress option to disable the preliminary calculation of a row number. This allows for increasing the performance for tables with a large number of rows. Uncheck this option to enable preliminary calculation of row number. In this case, the exact progress bar will be displayed.

    • Check the Use Row Limit option and then specify the exact number of rows to use in the data comparison operation. If the Use Row Limit option is unchecked, all objects will be compared.

  5. In the Detailed data comparison mode, you can modify the same table settings as described in items 2a and 2b. Also, you can use the options as described in items 4a and 4с. 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.

  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.

    • Check the Disable progress option to disable the preliminary calculation of a row number. This allows for increasing the performance for tables with a large number of rows. Uncheck this option to enable preliminary calculation of row number. In this case, the exact progress bar will be displayed.

  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.

    • Check the Disable progress option to disable the preliminary calculation of a row number. This allows for increasing the performance for tables with a large number of rows. Uncheck this option to enable preliminary calculation of row number. In this case, the exact progress bar will be displayed.

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

    • You can also specify the Percent of data to move in the appropriate data field.

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

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