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 co开发者_运维技巧mpare and sync database schema and data.

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.

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!

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.

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

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