This section covers comparing and synchronizing database schema objects other than tables — views, stored procedures, functions, etc. Some features related to detailed diff analysis are available only for the Standard version.
Object handling is covered in two ways:
Open databases (see the Schema Changes Summary use case) and click A NEW+CHG (new + changed) count for required object type, for example for Stored procedures. Or, you can click other counts to process all, only new or only changed objects.
Opened Object list tab contains list of all changed objects and objects entirely missing in the other database. To synchronize changes, B select required objects and click C Merge.
In the opened Execute script dialog, click D Run to execute generated script immediately, or E Copy / Save buttons to save generated script for future use.
Open databases (see the Schema Changes Summary use case) and click A CHANGED count for required object type, for example for Stored procedures.
Opened Object list tab contains list of all changed objects. Click B on required object name to analyze specific object changes in detail.
Opened Text diff tab contains object definition scripts from both databases. C New and changed lines are highlighted. Bottom of the screen contains D detailed comparison for selected line.
You can click E Show only new and changed to collapse unchanged lines, or apply similar filter to show only new or only changed lines. Unchanged lines are collapsed, leaving just a few unchanged rows for context, which can be configured F.
