Red - Object is missing from the side where the red item is shown, but present on the other side.Green - Object is present on both sides and the object's attributes on both sides match.In the figure below, the data types of the selected column do match in the source and destination schemas, as indicated in the detail panel.Įach node in the tree controls is colored using the following coloring scheme. When you select an object in either tree control, the 'Explain' panel at the bottom of the screen will give more details regarding the comparison results for the In that case, the trees will onlyĬontain objects that were found in both schemas/databases. The trees will contain all objects that were compared, unless the 'Only show objects present on both sides' checkbox is checked. Schema/database and the right one is the 'destination' schema/database. ResultsĪfter DB Solo has completed the comparison process, you will see the results presented as two tree controls. , the comparison may potentially take several minutes to complete. Notice that if the number of objects to compare is large There is a separate tab for each group of objects to compare.Īfter applying all the settings you wish to change, click on 'Next' to start the comparison. To re-enter the same settings next time you want to run the comparison. All settings will get persisted when you close DB Solo, so you don't have The various tabs in the settings screen allow you to fine-tune the comparison process. To save a database/schema on the results page of the tool, click on the Save-button highlighted in the picture below. Up a dialog where you can select the location of the snapshot file as well as options related to the saved snapshot. To save a database/schema on the first page of the tool, select the desired database/schema in the tree control and right-click on it and select the 'Save' option. You can save a database/schema to a snapshot file either on the first page of the Schema Compare Tool or on the last results page. To do so, uncheck the 'Compare All' checkbox and check/uncheck the items you wish to compare.Īfter selecting the schemas/databases and the associated objects to compare, click on 'Next' to move to the settings panel. The tabbed window at the bottom of the first screen allows you to hand-pick objects to compare. Comparable objects include Tables, Views, Functions, Stored Procedures, etc.īy default all of these objects will be compared in the selected schemas/databases. To open a previously saved snapshot file, click on the file folder icon and point to the file on your hard drive.Īfter selecting the source schema/database from an active database server or a snapshot file, you can select individual objects to compare within that schema. To compare a database or schema that you have previously saved to a snapshot file, select the 'Snapshot' tab under 'Source' or 'Destination'. The tree control on the left hand side allows you to select 'source' database/schema of the comparison and the right side lets you pick the 'destination' database/schema.įigure - Select Schema/Database Saved Snapshot To compare a database or schema on a live database server, select the 'Database/Schema' tab under 'Source' or 'Destination'. The database/schema to be compared can be either on a database server or a previously saved snapshot of a database/schema. Individual objects within the selected schema. The first screen of the comparison tool allows you to select the schemas/databases to compare as well as You can invoke the Schema Comparison Tool from the 'Tools' menu in the main toolbar of DB Solo. It also will detect column discrepancies in the column data type, identity, nullability and default value.Ĭomparison can be done between schemas on two identical DBMS platforms or two different DBMS platforms such as Oracle and SQL Server. It will report any discrepancies between schemas such as missing or mismatching stored procedures, tables, table columns, indexes and constraints. Schema Comparison Tool allows you to compare tables, views, functions, stored procedures and other database objects between two schemas/databases.
0 Comments
Leave a Reply. |