Viewing and Understanding Comparison Result

• Comparison Result View
• Using Object Navigation Tree
• Using Diff Area

Comparison Result View

On completing the schema comparison DBChangeManager provides a result view as shown below:

The Result view layout provides the following components:

• Object Navigation Tree: The left side of the result view provides an object navigation tree listing all the schema objects that were compared. You could click on any of the schema object and view the corresponding difference on the right side diff area. The navigation tree also provides various filtering and search options for quick access to the required schema object. Learn More...
• Diff Area: To the right of the navigation tree you find the schema Diff Area. The difference of a schema object present in Resource 1 and Resource 2 will be displayed in this area. You could also view the script that is generated for syncing the schema object along with warnings to be taken care before synchronization. Learn More...
• Diff Toolbar: The result view also provides a toolbar with options for common operations like Export Result, Synchronize and Recompare

Using Object Navigation Tree

The object navigation tree lists all the schema objects that were compared. Clicking on any schema object will provide the schema difference of that object in the right side diff area. In the navigation tree the objects will be categorized based on the type of object (table, views etc., ) as top level nodes for easy access.

Type of Difference:

To the left of every schema object listed in the navigation tree, an icon is associated to indicate the type of difference for that object. The following is a description of these icons and their associated meaning:

• Resource 1 Only: This icon indicates that the schema object is found only in Resource 1
• Resource 2 Only: This icon indicates that the schema object is found only in Resource 2
• Modified Resource: This icon indicates that the schema object present in Resource 1 and Resource 2 have difference between them
• Equal Resource: This icon indicates that the schema object present in Resource 1 and Resource are the same with no differences

Filter By Object Type:

You could filter the objects based on their type using the Filter option menu on top of the navigation tree. Clicking on the Filter brings up a selection popup as shown below. You could check/uncheck the type of the objects that you wish to see or not in the navigation tree. You could also check/uncheck the Show/Hide All option to view all the type of objects or to hide all of them.

Filter By Diff Type:

You could filter the objects based on the type of difference too. This could be done through any of the following means:

• Diff Type Tabs: On the top of the navigation tree by default all the schema objects that has been compared are listed under the "All Objects" tab.
  • Clicking on (Resource 1 Only) tab will list only the objects that are found in Resource 1
  • Clicking on (Resource 2 Only) tab will list only the objects that are found in Resource 2
  • Clicking on (Modified Resource) tab will list the objects that are present in both Resource 1 and Resource 2, but has differences
  • Clicking on (Equal Resource) tab will list the objects that are present in both Resource 1 and Resource 2 with no differences
• Similar options are also provided as check boxes in the Filter option menu on top of the navigation tree

Searching Objects:

You could search for any schema object using the search box at the top of the navigation tree. The search does a "contains" match of the string provided. For any search string provided DBChangeManager would list all the schema object names that contains the search string. Eg., search string "resource", will list all the schema object names that contains the word "resource".

Using Diff Area

To the right of the navigation tree you find the schema Diff Area. The difference of a schema object present in Resource 1 and Resource 2 will be displayed in this area.

Viewing and Understanding the Schema Difference:

When you select a schema object in the navigation tree the script difference of the object in Resource 1 and Resource 2 will be displayed in the Diff Area under the tab Difference. This area is presented in a two columnar model. The first (left) column will list the script of the schema object as present in Resource 1. The second (right) column will list the script of the schema object as present in Resource 2. Between the first column and the second column there is a split area which is used for highlighting the type of diff using appropriate icons.

The script of the schema object will be formatted and presented with syntax highlighting for easy readability. The differences in the script of the schema object in Resource 1 and Resource 2 are highlighted through appropriate color coding and icons as described below:

• Script present in Resource 1 only: The line(s) of script that is present only in Resource 1 and not in Resource 2 will be indicated with an icon in the split area, positioned corresponding to that line.
  
  
  
• Script present in Resource 2 only: The line(s) of script that is present only in Resource 2 and not in Resource 1 will be indicated with an icon in the split area, positioned corresponding to that line.
  
  
  
• Difference in Script: If a particular line(s) of script present in Resource 1 and Resource 2 are different, it will be indicated with an icon in the split area.
  
  
  
• Same Script: All the lines of the script which are the same in both Resource 1 and Resource 2 will be indicated with an icon in the split area
  
  

Quick Navigation through differences:

Diff Area also provides Next-Previous (present on the right top corner) buttons to quickly navigate across the differences in the script of the schema object. Clicking on the Next button will select the next difference in the script area. Similarly clicking on the Previous button will select the previous difference in the script area.

Font Size Settings:

You could alter the font size of the script displayed in the diff area by using the   icons at the right top corner. Pressing will increase the font size of the script. Pressing will decrease the font size of the script.

Viewing Synchronization Script:

You could view the Synchronization script that would be used by DBChangeManager to synchronize the selected schema object either in Resource 1 or Resource 2 database by selecting the Sync Script tab.

The Sync Script tab is horizontally split into two areas:

• Top area displays the synchronization script that would be used to update the schema object in Resource 1 database based on the schema object details in Resource 2 database
• Bottom area displays the synchronization script that would be used to update the schema object in Resource 2 database based on the schema object details in Resource 1 database

Synchronization Warnings:

DBChangeManager also provides warnings, if any, that are to be considered while synchronizing the selected schema object in either Resource 1 or Resource database. You can view the warnings by selecting the Warnings tab.

As in Sync tab, Warnings tab is also presented as horizontally split areas:

• Top area displays any warnings to be considered for synchronizing the schema object in Resource 1 database based on the schema object details in Resource 2 database
• Bottom area displays any warnings to be considered for synchronizing the schema object in Resource 2 database based on the schema object details in Resource 1 database