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
On the Tools menu, click Options.
The Options dialog box appears.
Expand the Database Tools node, and then click the Schema Compare node.
You can configure your comparison options. For information about specific settings, see.
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.