Database object comparision script

[jessie9000]

does any one have a script.. to compare objects(tables, views, sps, func etc) between two different databases.


thanks

[skhanal]

I use a commercially available tool called Change Manager, there are others in the market too, like Data Compare.

If you can't buy a tool, then one option is to generate scripts for everything in your databases and use dos command fc to compare files. If you have visual studio you can also use windiff to compare text files.

[MAK]

http://www.red-gate.com/sql/summary.htm

[jessie9000]

Yeah Mak,

is there any thing for free.. or any scripts...

[MAK]

Nothing is free in this world.

Suggestion: Get the trial version and do it.

[jessie9000]

Thanks Mak IGotch you...