How to: View Schema Differences
After you compare database schemas, Team Edition for Database Professionals displays the comparison results in the Schema Compare window. The results appear in a tree grid, and the nodes in the grid (folders) represent types of database objects, such as tables and views. For more information, see Overview of Comparing Database Schemas.
After you view the schema differences, you can synchronize some or all of the database objects that are different, missing, or new by updating them in the target database. For more information, see How to: Synchronize Database Schemas.
To view schema differences
Compare the schemas of a source and a target. For more information, see How to: Compare the Schemas of Two Databases.
After the comparison finishes, the grid in the Schema Compare window displays information about the database objects that you compared.
(Optional) Change the way you view comparison results, in any of the following ways:
Filter by status. By default, you see all objects, whether they are different, missing, equal, or new. To filter objects by status, click the Filter list on the Schema Compare toolbar, and then click the view that you want.
Note
Your filter selection does not persist between comparisons.
Focus on types. You can also view only particular types of database objects, such as tables, views, or stored procedures. In the tree grid, expand the nodes whose contents you want to see, and collapse other nodes to hide their contents.
View definitions and scripts. In the Object Definitions pane, you can see the definitions of database objects. In the Schema Update Script window, you can see the script that you can use to synchronize the databases. For more information, see Overview of Comparing Database Schemas.
Note
To open the Schema Update Script window, click Show Schema Update Script on the Schema Compare toolbar.
See Also
Concepts
Terminology Overview of Team Edition for Database Professionals