Menu
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.
601
SQL Compare is a tool for comparing and synchronizing SQL Server database structures. It is used by over 150,000 database administrators, developers and testers. SQL Compare automates the process of distributing database changes made on a local database to testing, staging or live databases on remote servers.
Right-click on the right/left panel and click the Difference highlights option from the context menu. Go to the View tab in the main application window and click the Difference highlights button.
Datanamic DataDiff is a powerful and easy-to-use utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely.
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.
92
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
