Database Comparison

[ravi]

We are converting our project into new version. They have done lot of changes in new version including normalization/denormalization. I need to compare the old and new database.
Do you have any standard script or procedure like SQL Compare software?.
Let me know what are the possibilties we need to check.
Your help appreciated.
Thanks,
Ravi

[rmiao]

Not easy without proper tool. How big the db is? How many objects need to compare?

[skhanal]

SQL Compare or Embarcadero change manager only costs about $300-$400 for a license and they are good tools to have.

If you don't want to spend money, then use Enterprise Manager to generate scripts for all the objects in the database in both environments (save the result in one big file for each environment), use visual studio 's file compare utility to compare the script files (I forgot the name of the tool that comes with VS)

[rmiao]

SQL Compare can compare data as well.

[ravi]

Rmiao/Skhanal,
our database has 450 common tables and 5000 field.
I aware of that the third party software/tool availability.
I juste wanted know if you have any standard procedure or script to check.
If you have any better advice realy appreciated.
ravi

[MAK]

If you like to save money on the 3rd party tool or if the client have restrictions.

Script out all the objects (one file per object) in a folder. Do the same in old database.

Then use COMP and FC (DOS commands) to compare the size and differences respectively.

This is tediuos process. (you can write a batch file to compare all the objects and output the results in a file)