Comparing two databases

I am using SQL Server 2008, can you recommend me some tool that I will be able to compare two database instances?

Also I want to be able to choose what tables and co开发者_如何学JAVAlumns should participate in the comparison.

I want to add it to our automation testing.

Thanks.

Red Gate's SQL Data Compare can do what you need. It is not particularly expensive, especially if you buy it as part of a bundle (check out some of their other products - they have a lot of useful tools) and you get a free trial so you can see if it works for your situation before you buy it.

I have used it and it works well. It allows both comparison and snychronization of data between two databases, even if the schemas are slightly different.

For the feature "Command line automation for continuous integration" you will need the Pro edition.

If you're using Visual Studio 2010 for coding along with SQL Server 2008, you can use the Schema Compare and Data Compare tools that comes along with Visual Studio 2010.

Here are some resources:

• Schema Compare
• Data Compare