Developers, data architects, and others who regularly work with databases often need to locate changes, find differences, or synchronize the database tables. Keep your databases up-to-date with the below tools as it’s simple, easy to use and fast. Synchronizing your development databases to production is a snap; a few clicks and the differences are scripted and applied to your target.
Below is the list of tools which includes a powerful database compare and merge tool to satisfy all these requirements. List number doesn’t specify any ranking.Also few tools are free, few trial versions are free & few are paid.
DBComparer is a professional database comparison tool for analyzing the differences in Microsoft SQL Server 2008 (and 2005) database structures. It is an excellent tool for any project development team or DBA managing multiple copies of the same database on an SQL Server. This database comparison tool has a clean and straight-forward user interface. Results are clearly presented so that you can immediately see the differences in your databases. It will make locating and eliminating differences in your database fast and easy.
2. SQL Delta
Keep your databases up-to-date with SQL Delta. SQL Delta lets you manage one comparison or hundreds with its advanced project manager. Synchronizing your development databases to production is a snap; a few clicks and the differences are scripted and applied to your target.
3. Altova DatabaseSpy
DatabaseSpy® 2012 displays database comparisons in an intuitive graphical table representation with connecting lines to illustrate column mapping between tables. DatabaseSpy® 2012 automatically maps columns with the same names, or you can drag connecting lines to manually map columns for comparison.
4. Adept SQL
AdeptSQL Diff is a lightning fast and intuitive tool to visually compare and synchronize two MS SQL Server databases. The program scans both databases and displays the combined schema tree view, with all differences color-marked.