CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Night Walker
Night Walker

Reputation: 21280

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 columns should participate in the comparison.

I want to add it to our automation testing.

Thanks.

Upvotes: 2

Views: 218

Answers (2)

Bryan Hong
Bryan Hong

Reputation: 1483

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:

Upvotes: 0

Mark Byers
Mark Byers

Reputation: 839254

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.

Upvotes: 3

Related Questions