Open topic with navigation

Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6
You are here: Compare Data > Data Compare Options > Comparison Default Options

Comparison Default Options

Use these options to set objects and properties to exclude when comparing data.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set comparison defaults

  1. Select Tools | Options.

  2. Select Data Compare | Comparison Defaults.

  1. Review the following for additional information:

    Comparison Description

    Ignore case in text data

    Ignore any differences in case within the data. If cleared, any change in case is marked as a difference (for example, "JSmith" and "jsmith".  

    Default: Cleared

    Ignore whitespaces

    Ignore any differences in spacing when comparing data.

    Default: Cleared

    Ignore BLOB columns

    Ignore any objects that contain large fields or binary data.

    Default: Cleared

    Ignore GUID columns

    Ignore any differences in Globally Unique Identifier (GUID) fields.

    Default: Cleared

    Ignore timestamp columns

    Ignore any differences in timestamps when comparing data.

    Default: Cleared

    Ignore auto-increment columns

    Ignore any differences in auto-increment (or identity) values when comparing data.

    Default: Cleared

    SQL Server Script Description

    Drop/create foreign keys

    Disable foreign keys when synchronizing data.

    Default: Cleared

    Drop/create primary keys and unique constraints

    Modify primary keys and unique constraints by dropping and recreating them when synchronizing data.

    Default: Cleared

    Disable triggers

    Disable all triggers when synchronizing data. This ensures that a trigger does not fire when accessed during synchronization.

    Default: Cleared

    Use transactions

    Specify the method to use for committing transactions:

    • Commit the entire generated SQL script

    • Commit each table in a transaction

    • Commit each operation in a transaction

    • Commit every N statements in a transaction

    If an error occurs during script execution, the transaction is rolled back depending on the option selected.

    Default: Cleared

    Ignore identity

    Exclude any identity values in the synchronization script. If selected, values are automatically generated by the server when creating the syncrhonization script. If cleared, the target table is populated with the same identity values as the source table (note that this is not supported by UPDATE operations).

    Default: Cleared

Tips:

 

of