Schema (Diff) Difference Tool
-Provides a user with a graphical interface depicting differences between schemas from the same or a 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 (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. |