Softpedia >Windows >Internet >Servers >Database Utils >EMS DB Comparer for MySQL >  Changelog

EMS DB Comparer for MySQL Changelog

What's new in EMS DB Comparer for MySQL 5.0.0 Build 55183

Dec 28, 2021
  • Support for dark visual scheme added.
  • Work with objects filter considerably improved.
  • Support for Unicode database names added.
  • Excluded objects are saved to the template correctly now.
  • READONLY option for procedure arguments was missing in synchronization script. Fixed now.
  • The size for datetype2 is now processed properly.
  • Many other fixes and improvements.

New in EMS DB Comparer for MySQL 4.3.3 Build 51846 (Oct 3, 2018)

  • Refresh of objects on MySQL 8.0 has been fixed.
  • The buttons for easy moving between differences in DDL have been added.
  • Comments are now compared and sychronized as Unicode.
  • Minor improvements of the interface.
  • Localizations are now switched correctly.
  • Other minor bug-fixes in generated script.

New in EMS DB Comparer for MySQL 4.3.2 Build 49824 (Feb 6, 2018)

  • The console version failed on displaying logs longer than 104 characters. Fixed now.
  • Database name is now correctly displayed in reports.
  • Subobjectes were not ignored on disabling the object in the database tree.
  • 'Show objects list' option didn't work properly sometimes. Fixed now.
  • Defaults are now displayed correctly.
  • 'Recompare' button is now disabled during comparison process.
  • Other minor improvements and bugfixes.

New in EMS DB Comparer for MySQL 4.2.0 Build 45182 (Jan 27, 2015)

  • Added the comparison of procedure parameters.
  • Delimiters are added in the synchronization script.
  • Added the possibility of using INFORMATION_SCHEMA.
  • The algorithm of calculating dependencies has been improved.
  • Objects filters are improved now: regular expressions can be used.
  • The error occured on connection timeout. The connection is re-established automatically now.
  • Index comparison is improved now: comments and specific properties of MySQL 5.5 are compared.
  • Lots of other improvements and bug-fixes.

New in EMS DB Comparer for MySQL 4.1.0.2 (Dec 4, 2012)

  • Added support of the previously unsupported index properties.
  • Added the possibility to save the project at any step of the wizard.
  • Added the possibility to bulk turn on/turn off the object properties at the “Compare properties” step.
  • Other improvements and bugfixes.

New in EMS DB Comparer for MySQL 4.0 (Dec 4, 2012)

  • 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

New in EMS DB Comparer for MySQL 3.3.1.6 (Dec 1, 2011)

  • Unicode support is added
  • Firebird 2.1 support is added
  • Added the possibility to compare FEDERATED tables (MySQL)
  • Added the possibility to connect through the Connection string (Oracle)
  • Added the option to exclude the DEFINER parameter when comparing procedures (MySQL)
  • Now the CREATE OR REPLACE statement is used to modify objects (PostgreSQL)
  • Primary keys with system names are now synchronized correctly (SQL Server)
  • The “Load last passwords for new projects” function sometimes loaded wrong passwords. Fixed now
  • Other minor fixes and improvements

New in EMS DB Comparer for MySQL 3.2 (Dec 1, 2011)

  • PostgreSQL 8.3 support is implemented.
  • Indexes with automatically generated names used to be compared improperly. Fixed now. (SQL Server)
  • Scripts to add the AUTO_INCREMENT field into a table which already contained a primary key were generated improperly. Fixed now. (MySQL)
  • The possibility to compare invalid and broken objects is implemented. (Oracle, MySQL)
  • Database comparison speed is considerably increased.
  • Other minor fixes and improvements

New in EMS DB Comparer for MySQL 3.1 (Dec 1, 2011)

  • When comparing a Firebird 2.0 database with the one on the Firebird 2.1, identical views used to be marked as different. Fixed now. (InterBase)
  • 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. (MySQL)
  • The rules were skipped when creating views. Fixed now. (PostgreSQL)
  • Partition Functions used to be generated before the Partition Schemes were created. Fixed now. (SQL Server)
  • The modifying script used to be generated twice for domains with different size of type. Fixed now. (InterBase)
  • The functions with DECIMAL parameters different in dimension used to be compared improperly. Fixed now. (SQL Server)
  • When synchronizing constraints stored at servers of 2000 and 2005 versions, the Default value for SQL Server 2005 used to be generated in double parentheses (e.g. ((1))). Fixed now. (SQL Server)
  • When comparing an SQL Server 2000 database with the one on SQL Server 2000, identical UDFs used to be marked as different. Fixed now. (SQL Server)
  • When comparing databases on Chinese Windows localization, the “Error: RichEdit line insertion error” message used to appear. Fixed now
  • Other minor fixes and improvements

New in EMS DB Comparer for MySQL 3.0 (Dec 1, 2011)

  • Major improvements in comparing engine, now comparing process uses object dependencies information. The synchronization process needs much fewer manual operations
  • Redesign of User interface:
  • New improved object tree
  • Added grouping schemas in object tree
  • Added Object Properties Viewer showing differences in objects visually
  • One-click report for databases differences
  • Now the application is more friendly and easy in use
  • Utility source code significantly optimized, work speed increased. Databases comparison is much faster now
  • Now the schema vs schema comparison is available. You can compare and synchronize schemas of different databases as well as on a single database (for PostgreSQL, SQL Server, Oracle)
  • Advanced filtering capabilities when selecting objects to compare/synchronize. Now you can exclude separate objects or object groups from comparison and synchronization
  • New improved SQL Editor:
  • Transaction management ability
  • Detailed error messages
  • Easy focusing on error statements
  • Added code completion feature
  • Improved SSH Tunneling: (for MySQL, PostgreSQL, InterBase / Firebird, Oracle):
  • Added SSH private key authentication
  • Separate SSH connections to different servers
  • Advanced synchronization is easier and faster
  • Ability to save and print reports of databases differences. You can use built-in reports or create your own
  • Latest SQL server version support
  • Other bug-fixes and improvements

New in EMS DB Comparer for MySQL 2.2 (Dec 1, 2011)

  • The opportunity to connect through SSH/HTTP tunnel added
  • The ability to filter analyzed objects using regular expressions added. This allows to analyze only objects you need and increases the speed of comparing and analyzing processes
  • Visual representation of definition differences implemented. Now it is clearly understandable which lines of objects definitions differ
  • The 'Hide identical objects' option added. This option allows to hide identical objects in DB Tree
  • Large databases are now compared faster
  • Ability to refresh different types of objects separately implemented. This is helpful when you synchronize databases in step-by-step style
  • Toolbar with list of working windows is added to main window
  • The 'Synchronize databases after comparing in console mode' option added. This project option allows to run console application in synchronization mode by default (without defining /E option)
  • The 'Fill Table View on load' option added. This option allows 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
  • Passwords were not saved correctly in some cases. Fixed now
  • 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
  • The ‘Group by schemas’ option added. This option allows to group objects in DB Tree by schema/owner (SQL Server)
  • Procedures containing differences in their parameters were not synchronized correctly. Fixed now. (SQL Server)
  • UDFs were compared incorrectly. Fixed now (SQL Server)
  • The ability to compare two schemas (including the schemas of the same database) added (PostgreSQL)
  • Functions containing differences in their return types were not synchronized correctly. Fixed now (PostgreSQL)
  • Altering procedures scripts were generated incorrectly. Fixed now (IB/FB)
  • Views were compared with error. Fixed now (IB/FB)
  • Other minor improvements and small bug-fixes

New in EMS DB Comparer for MySQL 2.1 (Dec 1, 2011)

  • Now it’s possible to save the synchronization direction in the project file, thus now the console version considers the synchronization direction.
  • InterBase/Firebird: Now it is possible to choose client library.
  • Now it’s possible to export grid view into excel, text, xml, html formats.
  • A new, more detailed console application log is implemented.
  • Now it’s possible to select fields from the list when creating user reports.
  • Fixed the bug with display of hints for the object tree.
  • When creating a new report there were no pages. Fixed now.
  • When changing Compare Options for a project sometimes the Access Violation error emerged. Fixed now.
  • InterBase/Firebird: Fixed multiple errors with synchronization of triggers and procedures.
  • Other small bug fixes and improvements.