sql server 2005 compare tool

[gwu]

We are trying to find a sql server comparison tool that supports 2005.

Many of the tools out there do not support 2005 yet.

thanks

 

[SQLDenis]

here is one
All the new objects, assemblies and datatypes in SQL Server 2005 are fully supported with automated intelligent comparison and synchronization

http://www.red-gate.com/products/SQL_Compare/index.htm

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[icemel]

SQLDenis - is it any good?

 

[SQLDenis]

I am using the 2000 version and when a developer went on vacation but forgot to tell me all the changes this tool saved my life
Download a trial and play around with it, it's really easy to use
It will script out everything for you
show you objects that exists on server A but not server B and reverse and also objects that exist on both servers but are not identical
when you click on those objects it will show you the code in 2 windows with the differences highlighted



Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/