CODEWITHSUNDEEP
sqlcomparison
David Ward
David Ward

Reputation: 3829

SQL Comparison Tools

Which SQL comparison tool would you recommend for SQL server database comparisons. I've been looking at SQL Compare and SQL Delta. I'd like the ability to compare and sync database schema and data.

Upvotes: 6

Views: 317

Answers (5)

Rody
Rody

Reputation: 2655

If you are working with Visual Studio Database edition or higher, you can do this straight inside Visual Studio. See the following link: http://www.vitalygorn.com/blog/post/2008/01/Handling-Database-easily-with-Visual-Studio-2008.aspx (dead link)

It's been in there since VS 2005.

Upvotes: 4

Devart
Devart

Reputation: 121922

You should take a look at Devart's dbForge Schema Compare for SQL Server and dbForge Data Compare for SQL Server.

Upvotes: 0

KZoal
KZoal

Reputation: 64

I hvae used RedGate. It allows you to do the schema comparison and also data comparison.

Upvotes: 1

Will Marcouiller
Will Marcouiller

Reputation: 24132

I guess you could use the ones provided by RedGate Softwares (which you enumerated). They are reliable, easy to use and, as far as I'm concerned, very effective!

Upvotes: 2

Coding Flow
Coding Flow

Reputation: 21881

I like Adept SQL Diff, it works really well and is easy to use. I find it more intuitive than redcate SQL compare. It also includes schema and data diff/sync tools whereas with redgate they are 2 differnt applications.

Upvotes: 1

Related Questions