Share via


How to: Set Options for Comparing Database Schemas

You can configure options to specify more exactly what is considered a difference between databases or database projects. You can set global options that affect the default comparison options for all new sessions of Schema Compare. You must refresh existing sessions of Schema Compare for the changed options to take effect.

To set global options for Schema Compare

  1. On the Tools menu, click Options.

    The Options dialog box appears.

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

    You can configure your comparison options. For information about specific settings, see Options (Database Tools/Schema Compare).

  3. After you finish configuring your options, click OK to commit those changes. At any time, you can click Cancel to discard the changes.

    When you commit your changes, any new sessions of Schema Compare use the new settings. Existing sessions keep the settings that were in effect when the session was created until you refresh the results window.

See Also

Tasks

How to: Compare the Schemas of Two Databases

Concepts

Overview of Comparing Database Schemas
Terminology Overview of Team Edition for Database Professionals