Monday, September 05, 2005

Comparing SQL Server Databases

PowerDesigner, it’s a modeling tool from Sybase.

1.Just generate the SQL definition for the databases from inside the SQL Server and then import them to the PowerDesigner.
2. Once you have imported both databases in the PowerDesigner you can do many things.

3. You can compare the definitions and the PowerDesigner will generate a complete report with the differences between the two databases. The report will include tables, Keys, Indexes, views … etc

No comments: