Copy the redgate extentions from other (working version) to C: Program Files (x86) Microsoft SQL Server 140 Tools Binn ManagementStudio Extensions then restart the SSMS and it should work.
Joel is always talking about how great SQL Compare from Redgate software is. SQL Compare only works with Microsoft SQL Server databases, but is there a good piece of software that works with MySQL and the other common databases that are part of the LAMP stack (PostgreSQL, Oracle, etc)?
Red Gate now has MySQL Compare & MySQL Data Compare
you can use Toad for MySql , it has a compare features
Maatkit also support several different RDBMS
Winsql is a good windows application that uses odbc to connect to any db and has compare tools. Here's the address: http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp
Sure, this is an old thread, but it's much younger than MySQL.
I'm currently evaluating 'Navicat', which does schema and data synchronisation for the following databases: MySQL, MariaDB, SQL Server, SQLite, Oracle and PostgreSQL. It seems to be a bit cheaper that the Red-gate tools.
It also has some extra stuff: SSMS-like functionality (i.e. design tables, views etc.), data modelling - i.e. reverse engineering tables/relationships into an editable diagram. Doesn't seem to have DB source control.
P.S. - I have no affiliation to this company, or software - just checking it out. Seems to fit the bill.
Godsw SQLCompare is a perfect tool which you can use to compare databases and synchronize the structure of Microsoft SQL Server databases. This is useful in a development environment when changes made to a local database need to be cloned to a. ...
With AdeptSQL Diff, you can visually compare two MS SQL Server databases, then produce and execute difference scripts for a choosen part or for the whole schema. Also compares table data. Very fast and easy to. ...
SQL Delta is a great value, fast SQL Server 7, 2000 and 2005 database compare tool used to analyze, compare and synchronize database structures and data. SQL Delta will script the differences between two databases allowing you to synchronize the two. ...
Compare and synchronize SQL DBMS data visually between two databases using ODBC drivers Compare and synchronize SQL DBMS data visually between two databases using ODBC drivers CompareData is a native Windows cross-dbms application that allows you to visually compare and synchronize data between two SQL databases using ODBC drivers. You can retrieve all/some data for a table/view from two databases and compare the data visually to see differences highlighted on the screen.
DBC ensuring your applications don't fail due to a missing database structure object DBC (Database Compare) is a fast, comprehensive database structure and data comparison tool. DBC can compares the schema of two Microsoft SQL Server databases and. ...
SQLcompare and synchronization for SQL Server, Oracle, MySQL, SQL Azure, Acces. SQL Data Examiner 2010 R2 is a reliable and user-friendly tool for comparing and synchronizing databases. SQL compare and synchronization is made easy with this solution.
ApexSQL Data Diff is a SQL Server database comparison tool used to compare and synchronize database data. It also supports comparing SQL Azure databases, database backups, CLI. It can automate and schedule database migrations, propagate data changes from . ...
dbForge DataCompare for SQL Server is a tool to compare and sync data of SQL Server databases. Analyze data differences in a well-designed user interface and synchronize comparison results in a convenient wizard.
SQL Server replication is a fantastic piece of functionality but can lead to a database administration nightmare. Data conflicts are a common occurrence and require constant attention. SSW SQL Total Compare reports the differences between the. ...
SQLData Examiner 2010 is a reliable and user-friendly tool for comparing and synchronizing databases. SQLcompare and synchronization is made easy with this solution. The software supports Microsoft SQL Server, MySQL, Access and Oracle database. ...
D-Softs Database Comparer is a powerful and fast mssql database compare tool. It not only can be used to compare schemas of two databases, and the contents of two databases can also be compared. It supports thirty mssql database Objects Types, with. ...
xSQL DataCompare is a professional SQL tool for comparing and synchronizing SQL Server database contents. It is used for data migration, database copy, replication verification, data auditing, scripting schema and data together etc. Features. ...