SQLDBCompare

Comparing Individual Database Items

Comparing two individual objects will provide the details of differences between the two objects. The SQL objects must be in the same type, but not necessarily to be in the same name.

Select the Object to Compare

The first step is to select the individual database object as the comparing objects:

In the Database Object 1 Pane that is the left pane, select the individual object. Its object type will appear as the Comparing Object Type and its name will also show up in the Name field in the left pane.
In the Database Object 2 Pane that is the right pane, select the individual object. Its object type will appear as the Comparing Object Type and its name will show up in the Name field in the right pane.
Click on the Compare button.

Figure 1 Select Individual Object to Compare

If the two selected objects have different types, the system will pop up a message for the error.

Figure 2 Comparing Objects with Different Types

View Comparison Result

If the two objects have the same type but different in the script/structure, the result will be displayed in the Show Difference window. Added, deleted and changed lines are in displayed in different background colors (see Figure 3).

If the structures of two objects are the same, a message window will pop up informing users they are identical. For tables, in addition to table structure, the number of records is compared (see Figure 4 and 5).

Figure 3 Show Object Difference

Figure 4 Object (except Table) is Identical

Figure 5 Table Object is Identical in Structure but Different in Total # of Records