EMS logo

Products Navigation

DB Comparer for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS DB Comparer for MySQL

On-line Documentation

Version history


 

Product name

Version

Release date

Data Comparer for MySQL

Version 4.0.0.1

December 8, 2011

Data Comparer for MySQL

Version 3.3.0.1

October 7, 2009

Data Comparer 2007 for MySQL

Version 3.1.0.1

April 10, 2008

Data Comparer 2007 for MySQL

Version 3.0.0.1

September 17, 2007

Data Comparer 2005 for MySQL

Version 2.2.0.1

August 28, 2006

Data Comparer 2005 for MySQL

Version 2.1.0.1

April 17, 2006

Data Comparer 2005 for MySQL

Version 2.0.0.1

March 9, 2006

MySQL DB Comparer

Version 1.3.0.1

March 8, 2005

MySQL DB Comparer

Version 1.2.0.1

February 11, 2004

MySQL DB Comparer

Version 1.1.0.1

November 10, 2003

MySQL DB Comparer

Version 1.0.0.1

May 14, 2003

 

 

 

Full version history is available at http://www.sqlmanager.net/products/mysql/dbcomparer/news

 

Version 4.0

  • The algorithm of object comparison and script generation is significantly improved, now it takes into account all particularities of MySQL server.
  • Added the possibility to search and analyze the renamed objects. The application now analyzes databases and creates a list of objects, which might have been renamed.
  • Added the possibility to synchronize a fields order in the tables.
  • Added the Project Management Wizard.
  • The list of comparison properties for objects is expanded, that makes the database analysis more complete.
  • Added the possibility to compare / synchronize users and rights on the objects.
  • Added the support of new Windows 7 features: a progress bar in the taskbar and Jump List with a list of projects.
  • Some other improvements and bugfixes.

 

 

Version 3.3

  • Unicode support for metadata is implemented.
  • Federated tables can now be compared.
  • DEFINER parameter can now be excluded from procedure comparing.
  • "Load last password for new projects" option worked sometimes wrong Fixed now.
  • Other small improvements and fixes.

 

 

Version 3.2

 

  • Scripts to add the AUTO_INCREMENT field into a table which already contained a primary key were generated improperly. Fixed now.
  • The possibility to compare invalid and broken objects is implemented.
  • Database comparison speed is considerably increased.
  • Other minor improvements and bug-fixes.

 

 

Version 3.1

 

When comparing a MySQL 4.1 database with the one on MySQL 5.0, identical table fields of INT type used to be treated as different. Fixed now

  • When comparing databases on Chinese Windows localization, the "Error: RichEdit line insertion error" message used to appear. Fixed now
  • Other minor improvements and bug-fixes

 

 

Version 3.0

 

  • Comparing and synchronization of databases or schemas on different servers as well as on a single server
  • Comparing all database objects or selected ones only. Comparing by all or selected properties of objects only
  • Visual representation of the differences between databases with details and modification scripts for the different objects
  • Ability to synchronize databases manually step by step or automatically
  • Ability to generate reports with database differences. Ability to add custom reports
  • Ability to automate the database comparison and synchronization using the Console Application
  • Working with several compare projects simultaneously
  • Saving and loading projects with all their parameters
  • A wide variety of options for comparison and synchronization
  • Built-in SQL Script editor with syntax highlight
  • New state-of-the-art graphical user interface
  • Latest MySQL version support

Scroll to top

 

Version 2.2

 

  • Added the ability to filter analyzed objects using regular expressions. This allows one to analyze only required objects, and increases the speed of comparing and analyzing processes
  • Added the opportunity to connect via SSH/HTTP tunnel
  • Visual representation of definition differences implemented
  • The 'Hide identical objects' option added. This option allows one to hide identical objects in the DB Tree
  • Large databases are now compared faster
  • Ability to refresh different types of objects separately implemented. This may be helpful when you synchronize databases in the step-by-step style
  • Toolbar with list of working windows is added to the main program window
  • The 'Synchronize databases after comparing in console mode' option added. This project option allows you to run the console application in synchronization mode by default (without defining the /E option)
  • The 'Fill Table View on load' option added. This option can be used to increase the speed of comparing process and decrease memory usage
  • The ability to set the default directories for grid exports and reports storage added
  • No more delays occur while navigating DB Tree with large databases
  • Fixed the saving passwords error
  • Procedures were not compared correctly in some cases. Fixed now
  • Functions were not compared correctly in some cases. Fixed now
  • Sometimes an error occurred while refreshing databases. Fixed now

and other minor improvements and small bug-fixes.

Scroll to top

 

Version 2.1

 

  • Now the direction of synchronization can be saved in the project file (also can be used by the Console application)
  • Export to Excel, Text, XML and HTML formats is now available from the Grid view
  • New, more detailed console application log is implemented
  • Now it is possible to select fields from the list when creating user reports
  • Hints for the objects in tree are now displayed correctly
  • When creating a new report, its pages used to be missing. Fixed now
  • When changing Compare Options for a project, the Access Violation error emerged. Fixed now

Scroll to top

 

Version 2.0

 

  • Completely re-designed top-of-the-art user interface
  • Ample opportunities for customizing your working environment
  • New way of browsing differences between compared databases
  • Easy viewing of all different properties of database objects
  • Ability to print a pre-defined differences report or create a new one
  • New advanced comparison options
  • Improved sync script generation
  • Multilanguage support
  • A lot of other improvements and bug fixes

and more...

Scroll to top

 

Version 1.3

 

  • Fixed a bug concerned with incomplete maximization of the main program window
  • MySQL 5.0.1 support
  • For some MySQL 4.1.x versions table type was incorrectly determined as MyISAM. Fixed now
  • Some minor visual improvements and bug-fixes.

Scroll to top

 

Version 1.2

 

  • Implemented the console version of the database comparison utility: now you can schedule your database structure synchronization routine using the database utility
  • Now Data Comparer does not try to create a primary key if the table already has one. The utility drops the existing primary key and creates another one
  • Using this version you can compare and synchronize primary keys regardless of key names.
  • Now you can view project properties without actually loading the project file - just open it while holding down the Shift key
  • We have implemented synchronous scrolling in the Master Definition and Target Definition windows
  • Now project files are associated with particular database comparison utilities
  • Some small improvements and bug fixes

Scroll to top

 

Version 1.1

 

  • Significantly increased the comparison speed for the databases with large amount of objects
  • Now the fields order is considered on comparing tables. You can enable or disable this feature by using the 'Field order' option available within the Compare Options tab of the 'Project Options' dialog
  • Now you can view the project options just before the project loading. Check the 'Show Project Options before Loading' option available within the Project Options section of the Environment Options dialog to enable this feature
  • Added two new options to the Project Options section of the Environment Options dialog - 'Enable Forward Navigation' and 'Enable Backward Navigation'. Using these options you can customize the navigation behavior. If the forward navigation is enabled, you can navigate between the generated SQL scripts by selecting the proper objects from object trees, and vice versa (if the backward navigation is enabled)
  • Now you can copy the Object definition to the clipboard
  • Some small improvements and bug-fixes

Scroll to top

 

Version 1.0

 

Basic features:

  • Comparing databases on one server as well as on different servers
  • Synchronous navigation between database objects with displaying the corresponding scripts for modifying databases
  • Possibility of execution modification statements one by one or all together
  • Possibility of editing modification statements and changing their order
  • Built-in SQL Script Editor with syntax highlight
  • An ability to work with several compare projects at once, as well as save and load projects with all their parameters
  • Customizable and easy-to-use MDI Interface
  • A wide variety of options for customization
  • Keyboard templates for faster editing SQL scripts

and more...

Scroll to top

 

 



See also:

What's new