Online Documentation for DB Comparer for MySQL

Version history

 

 

 

Version 5.0.2

• Comparison of renamed objected added to the console version.
• Filter for compared objects improved.
• Batch or PowerShell file type can be now selected on saving the template.
• The issues of scaling the application window resolved.

 

Version 5.0.1

• Support for Windows 11 ARM implemented.
• The DDL of functions containing one string was not displayed correctly. Fixed now.
• Some improvements in dark schema interface.
• Fixes for report printing.
• "Load last password for new projects" option was not saved in some cases. Fixed now.
• Minor improvements and fixes.

 

Version 5.0

• Support for dark visual scheme added.

• Added support for SSL connections.
• Work with objects filter considerably improved.
• Support for Unicode database names added.
• Excluded objects are saved to the template correctly now.
• Support of Ed25519 keys implemented for SSH connection.
• Calculation of dependencies considerably improved.
• Many other fixes and improvements.

 

Version 4.3.5

• Improved processing of foreign keys.
• Some settings were not saved to a template file. Fixed now.
• Minor visual issues fixed in the script editor.
• Other minor fixes.

 

Version 4.3.4

• JSON parameter in functions was sometimes displayed incorrectly. Fixed now.
• NOT NULL option for TIMESTAMP fields is now synchronized correctly.
• Script for fields order was generated regardless of the corresponding option state. Fixed now.
• Functions and procedures were not compared correctly on different server versions with INFORMATION_SCHEMA used. Fixed now.
• Object Definition windows can be hided\opened from the main menu now.
• Default settings didn’t reset the folder to localization files. Fixed now.
• Error window in SQL script editor saves custom size now.
• Other minor fixes and improvements.

 

Version 4.3.3

• Refresh of objects in 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.

 

Version 4.3.2

• 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.

 

Version 4.3.1

• Script for renaming autoincrement fields has been improved.
• DELIMETER wasn't added for Functions and Triggers. Fixed now.
• Multiple SSH-passphrase prompt has been fixed.
• Generation of script for deleting triggers has been improved.
• DROP IF EXISTS statement added to the generated script, if possible.
• Lots of other improvements and bug-fixes.

 

Version 4.3

• Dependencies processing mechanism enhanced.
• The order of table fields was treated incorrectly. Fixed now.
• The possibility of getting information on fields from the `information_schema` database added.
• The BOOLEAN fields were compared incorrectly. Fixed now.
• Lots of other improvements and bug-fixes.

 

Version 4.2

• 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.

 

Version 4.1

• 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.

 

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.
• "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 DB 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

 

---