• 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

Preferences element

Specifies preferences for all operations in the scenario and cannot be combined with the “OpenProject” element.

Use the Add element to add a preference for an operation (scenario). It has to be used with the following elements:

Attribute Comment
side Required. Specifies the database which the preference will be applied to. May have the following values: “left”, “source”, “right”, “target”, and “both”. Values “left” and “source” have the same meaning. Values “right” and “target” have the same meaning, too. Use “both” value if you need to set the preference for both sides. Also, use “both” value if the preference cannot be applied to one side only.
parent Optional. Specifies the parent data object for the preference. Used only for some preferences in data operations. The type specification is required for this attribute. Supported types: “Table”, “View”.
name Required. Specifies the name of the preference.
value Required. Specifies the value of the preference.

Here’s the list of available preferences for schema operations and data operations.

Schema operations preferences

Name Description Operation
SC SS
comment_generated_scripts Comment generated SQL scripts. Possible values: “true”, “false”. Default value is “true”. +
exclude_check_constraints Exclude check constraints from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_computed_columns Exclude computed columns from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_defaults Exclude defaults from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_distribution_keys Exclude distribution keys from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_foreign_keys Exclude foreign keys from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_functions Exclude functions from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_indexes Exclude indexes from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_macroses Exclude macroses from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_packages_and_modules Exclude packages and modules from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_primary_keys Exclude primary keys from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_procedures Exclude procedures from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_rules Exclude rules from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_sequenses Exclude sequenses from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_shared_libraries Exclude shared libraries from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_sort_keys Exclude sort keys from operation. Possible values: “true”, “false”. Default value is “true”. + +
exclude_system_objects Exclude system objects from operation. Possible values: “true”, “false”. Default value is “true”. + +
exclude_synonyms Exclude synonyms from operation. Possible values: “true”, “false”. Default value is “true”. + +
exclude_tables Exclude tables from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_triggers Exclude triggers from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_unique_keys Exclude unique keys from operation. Possible values: “true”, “false”. Default value is “false”. + +
exclude_views Exclude views from operation. Possible values: “true”, “false”. Default value is “false”. + +
ignore_collation Ignore database collation property in schema operations. Possible values: “true”, “false”. Default value is “false”. + +
ignore_column_ordinals Ignore column ordinals property in schema operations. Possible values: “true”, “false”. Default value is “true”. + +
ignore_columns_nullability Ignore column nullability property in schema operations. Possible values: “true”, “false”. Default value is “false”. + +
ignore_extended_properties Ignore extended properties in schema operations. Possible values: “true”, “false”. Default value is “true”. + +
ignore_foreign_keys_action Ignore foreign key action property in schema operations. Possible values: “true”, “false”. Default value is “false”. + +
ignore_function—based_indexes Ignore function—based indexes in schema operations. Possible values: “true”, “false”. Default value is “false”. + +
ignore_parameters_types Ignore types of stored procedure or function parameters in schema operations. Possible values: “true”, “false”. Default value is “false”. + +
ignore_sequence_data_type Ignore sequence data type in schema operations. Possible values: “true”, “false”. Default value is “false”. + +
ignore_sequence_last_number Ignore sequence last number property in schema operations. Possible values: “true”, “false”. Default value is “false”. + +
ignore_sql_register Ignore registry of inner SQL of scripted objects in schema operations. Possible values: “true”, “false”. Default value is “true”. + +
ignore_view_columns_data_type Ignore column data types of views in schema operations. Possible values: “true”, “false”. Default value is “false”. + +

Operation abbreviations:

SC – Schema Comparison;

SS – Synchronization.

Data operation preferences

Name Description Operation
DC DS DM FC
batch_size Batch data size for bulk operations/number of rows in transaction in data synchronization. Default value is 100000. + +
binary_limit_size Size of binary value to hash. Default value is 256. +
check_constraints Check constraints while data is being inserted. Possible values: “true”, “false”.Default value is “false”. + +
columns_to_sort_by List of columns to sort rows before data comparison. If table has no primary key or unique index, it can be used to start the operation. Otherwise, the operation will not be executed if you don’t specify the sorting columns. The sorting colums are mandatory for data comparison in views because ther’s no primary keys or indices. Equivalent to list of columns in ORDER BY statement. +1 +1
compare_only_row_count Compare only row count. Possible values: “true”, “false”. Default value is “false”. +
date_comparison_mode Comparison mode for date values in data operations. Possible values: “Full”, “Do Not Compare”, “Ignore Time”, “Ignore Milliseconds”.Default value is “Full”. + +
enable_delete Enable to delete target data in data operations. Possible values: “true”, “false”.Default value is “false”. +
exclude_lob Exclude large objects comparison in data operations. Possible values: “true”, “false”.Default value is “false”. + + +
expand_foreign_keys Add target columns of foreign keys during comparison in schema operations. Possible values: “true”, “false”.Default value is “false”. +
exclude_datetime_columns Exclude columns with date time type. Possible values: “true”, “false”. Default value is “false”. +
exclude_time_columns Exclude columns with time type. Possible values: “true”, “false”. Default value is “false”. +
fire_triggers When specified, cause the server to fire the insert triggers for the rows being inserted into the database. Possible values: “true”, “false”.Default value is “false”. + +
ignore_case Ignore case of metadata object names. Possible values: “true”, “false”.Default value is “false”. + +
ignore_time_zone Ignore time zone property for date values in data operations. Possible values: “true”, “false”.Default value is “false”. + +
include_equal_rows Include equal rows into the result of data operations. Possible values: “true”, “false”.Default value is “false”. +2
include_ignored_columns Include ignored columns into the result of data operations. Possible values: “true”, “false”.Default value is “false”. +2
keep_identity Preserve source identity values. When not specified, the values for the identity column will be generated in the target database. Possible values: “true”, “false”. Default value is “true”. + +
keep_nulls Preserve null values in the target table regardless of the settings for default values. Possible values: “true”, “false”. Default value is “true”. +
row_filter Filter rows to compare in detailed data comparison operation. Equivalent to WHERE statement.Not set by default. +2
scale Number of digits after period for real numbers. Not set by default. + +
string_limit_size Number of symbols from string value to hash. Default value is 256. +
treat_empty_as_null Treat empty strings as null strings in data operations. Possible values: “true”, “false”.Default value is “false”. + +
trimming_mode Trimming mode for string values in data operations. Possible values: “None”, “Leading”, “Trailing”, “Both”.Default value is “None”. + +
truncate_target Truncate target tables in data operations. Possible values: “true”, “false”.Default value is “false”. +

1 – requires the “parent” attribute for operations “Data Comparison” and “Data Synchronization”.
“Detailed Data Comparison” doesn’t require this parameter.

2 – available only for the “Detailed Data Comparison” operation.

Operation abbreviations:

DC – Data Comparison or Detailed Data Comparison;

DS – Data Synchronization;

DM – Data Migration;

FC – Fast Data Comparison.