Table of Contents
You can compare two data models to view the differences and similarities. You can compare a database to a Power*Architect project or to another database.
The data model comparison provides you with a description of the two data models, highlighting their differences and similarities, which you can copy into a document or save to a text file. You can also use the data model comparison to generate and run a SQL script that will update the older database to match the newer data model.
To compare two data models:
Click
on the top toolbar, or select Tools » Compare
DM. The Compare Data Models dialog box appears.
In the Compare Older and With Newer sections, select the data models you want to compare.
Select Current Project - Include an open Power*Architect project in the comparison. The data model currently in the playpen will be used.
Physical Database - Include an existing database in the comparison. You must also select the connection Power*Architect will use to connect to the database. For more information, see the section called “Setting up Database Connections” .
From File - Include an existing Power*Architect project in the comparison. Click Choose and select the project.
Note: If you want to switch the items you've selected in the Compare Older and With New sections, click Swap.
In the Output Format area, select whether you want to create a SQL script or an English comparison.
Select the Suppress similarities check box if you want to include only the differences in the output.
Click Start. The data model comparison is created.
Note: The Start button is only available if both data models in the comparison are valid.
See the following sections for details on the information shown in the data comparison.