The Compare Editor compares the Data Definition Language (DDL) text of two database objects and shows the DDL for each object side-by-side in a split window. Any differences in text or changed elements between the two objects are high-lighted in the editor. You can browse the text or use the toolbar to review next/previous differences and next/previous changed elements.
Types of objects you can compare are:
- Database
- User
- Table
- Stored Procedure
- Macro
- User-defined Function
- View
Comparison of DDL Text of Two Databases
DDL Text Comparison of Table Objects
- Referenced Object
- The object you selected in the Data Source Explorer as the object to compare with another object. The Compare SQL Objects wizard presents only objects for comparison that are the same object type as the referenced object. The DDL text for this object displays in the left pane of the Compare Editor.
- Compared to Object
- The object you selected in the Compare SQL Objects wizard for comparison with the referenced object. The DDL text for this object displays in the right pane of the Compare Editor.
- Next and Previous Differences
- Use the Next Difference () and Previous Difference () functions to review the differences between the two displayed objects in sequence of occurrence. The editor highlights the next or previous difference as you review and compare the DDL text in the two object panes.
- Next and Previous Change
- Use the Next Change () and Previous Change () functions to review element changes in the two compared objects. The editor highlights the next or previous change as you review and compare the DDL elements.