How to: Set Options for Comparing Database Data

  • Article

You can configure options to specify more exactly what is considered a difference between the data that is contained in databases. The options also control the update script that is generated if you synchronize the data in the databases. You can set global options that affect the default comparison options for all new sessions of Data Compare. The options will affect existing sessions of Data Compare when you close the Options dialog box.

To set options for comparing database data

  1. On the Tools menu, click Options.

    The Options dialog box appears.

  2. Expand the Database Tools node, and then click the Data Compare node.

  3. Configure your comparison options.

    For information about specific settings, see Options (Database Tools/Data Compare).

  4. Click OK to commit your changes or click Cancel to discard the changes.

    After you commit your changes, any new sessions of Data Compare use the new settings. Existing sessions are refreshed with the new settings.

See Also

Tasks

How to: Compare and Synchronize the Data of Two Databases

Concepts

Compare and Synchronize Data in One or More Tables with Data in a Reference Database