October 27, 2008 at 9:09 am
Can anyone please point me to any SQL Scripts to compare two SQL Server 2005 databases. I like to compare at all object schemas, indexes, sp, functions, constraints, etc., but not at the data level (records).
Any help is appreciated.
Thanks.
October 27, 2008 at 9:30 am
If you're looking for a "quick fix" look then below is a link to a site that compared 12 different tools for doing this type of comparison.
http://www.sqlserverdirectory.com/sqlserver_product_reviews_SQL_Schema_Compare.htm
Most if not all these products have a fully functional evaluation edition that you can look at and decide which is best. To my knowledge there isn't a "free" way of doing this and I haven't come across any scripts to do so.
I've used both ApexSQLDiff and Redgate SQL Compare frequently and have found both to be very easy and useful
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply