This section covers comparing and synchronizing database schema objects other than tables — functions, stored procedures, 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 Views. 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 missing in the other database. Use filter B to show only new or only changed objects. The header shows C total counts, and the footer shows D text preview of the object definition changes.
To synchronize changes, E select required objects and click F Merge.
In the opened Execute script dialog, click G Run to execute generated script immediately, or H 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 Functions.
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.
