Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2006-10-18 : 03:09:58
|
| Hi all,Could anyone let me know if there are any Scripts available for comparing the schema differences between two SQL server databases?Thanks HHA |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-18 : 03:49:55
|
| Check this out:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73134[/url]Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-10-18 : 03:55:58
|
| Also there is the third party tool called as DB Compare which can be useful. its show you the exact difference between the schema and also you can generate the script based on the differences.Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-10-18 : 03:57:05
|
| I'd be inclined to use one of the many tools that exist to do this kind of thing. Have a look at DBGhost [url]http://www.innovartis.co.uk[/url] or Red Gate SQL Compare [url]www.red-gate.com[/url].Mark |
|
|
|
Hariarul
Posting Yak Master
160 Posts |
Posted - 2006-10-18 : 04:59:38
|
| Thanks all |
|
|
|
|
|
|
Database table structure compare.