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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 What is the best comparison tool?

Author  Topic 

walwinkle
Starting Member

6 Posts

Posted - 2011-01-11 : 20:50:13
Hi,

I have used the Redgate comparison tool in the past, I found it pretty good.
What is the best comparison tool for comparing SQL 2008 databases?
I want something that is 100% effective, finding differences in table structures, stored procedures, views, user accounts, data, etc.

thanks,
Dave

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-11 : 23:32:12
+1 to the Red Gate tools. I use the SQL Compare tool pretty regularly.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2011-01-12 : 00:25:47
We have the whole database project in the VS 2010 Team Foundation which has a inbuilt comparision tool.So if you already have the license for VS 2008 or 2010 Ultimate edition then no need to buy third party comparision tool.

PBUH

Go to Top of Page
   

- Advertisement -