Provides a user with a graphical interface depicting differences between schemas from the same or virtually any different database type (Oracle, DB2, Sybase, SQL server, Informix, My SQL and PostgreSQL).

Provides a list of object types from which the user can compare the selected objects. For example, the user can pick only functions, or only tables and views, or all of the existing object types to compare them in the two databases.

Allows the user to then see the difference between object DDLs.

Displays graphically the selected objects which are seen as being identical, different, non-existant or changed in some way in the counterpart database.

• There is a top panel and a bottom panel. The top panel depicts differences in database objects. The top panel colors are: green-green (not different), pink-white (existing in the first database but not in the second database), white-green (existing in the second database, but not in the first database) half-green/half-pink (existing in both databases but different).

• If you click on the object, the difference will be depicted in detail on the bottom panel as a difference in their DDLs. The legend (pink, green, purple) explains those differences from the bottom panel. The objects highlighted in pink represent the objects that still exist in one database that have been deleted from the other database. The objects highlighted in green represent the objects that have been added to one database and not the other database. The objects highlighted in purple are the objects that exist in both databases but have been changed in some way in one or the other or both.

Schema Compare Enhancements

• Object Permissions: Support for permissions in the comparison of objects. In the options, the user may now choose to include permissions in the DDL of each object to be used in the comparison of the objects.
• Background Processing: The progress dialog has now moved to the panel view of the comparison so the user may continue working on other tasks while the compare tool continues to work.
• Refresh: A "Refresh" button has been added to the toolbar allowing the user to requery for the object definitions in the database in case any changes to the schema have taken place.
• Data Compare: A "Data Compare" button has been added to the toolbar to allow the user to compare the data in the currently selected table.
• Save As HTML: The toolbar now contains a "Save As HTML" button that allows the user to save the compare results to HTML so that they may be saved and emailed to other users. The save provides the user different options such as layout, font, file name and the object choices.
• Preview in Browser: The toolbar now contains a "Preview in Browser" button that allows the user to preview the last saved compare results to quickly access the saved HTML.
• Difference Count: The object results now contain a column indicating the number of differences between the two matching objects.