Object Compare (Schema Compare) is not showing target only objects (4307194)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Object Compare (Schema Compare) is not showing target only objects
Description

When doing an 'Object Compare' on a schema between two databases, results returned are incorrect and don't match with the results returned when using the 5.6 version of the product. For example, 5.6 shows that there are triggers that exist only in the target database, however, these triggers do not display in 6.0
Cause

5.6 runs the old Schema Compare which has since been replaced with the fuller featured Object Compare. In 6.0, in order to see target only objects, the option 'allow dropping target only objects' should be checked prior to compare.
Resolution

Check option 'allow dropping target only objects'
It should be noted, however, that checking this box will also include DROP statements for the target only objects, so these should be unchecked prior to sending the sync script to the editor, if you do not wish to drop these objects.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title