EMS Data Pump for MySQL

Version history

Version 3.0

Implemented Unicode data support
Source DBMS schemas support has been implemented
Added an option allowing one to enable/disable refreshing of source objects on connection
Added an option specifying whether all source tables are selected by default at Step 3
Quoting identifiers for the source database can be customized at Step 4 now
Pumping BLOB fields using ODBC drivers v5.1 for MySQL was not possible. Fixed now
Latest versions of target MySQL DBMS are supported
It is now possible to clear tables before importing data
It is now possible to generate DROP TABLE statements
Implemented support of collations for tables
The wizard window is now resizable
The possibility to restart the wizard is added at the last step
It is now possible to specify the wizard step that will be opened after loading a template
It is now possible to start data import after loading a template
Implemented password encryption in templates and registry
A number of minor bug-fixes and visual improvements

Version 2.2

It is now possible to enforce quoting for object names in the result script for data import automatically (when applied to "unrecognized" OLE DB/ODBC providers)
Implemented Private Key support for SSH authentication
Added an option allowing one to specify the default MySQL table engine type (Step 3)
Added French and German interface localizations for the utility
A number of minor bug-fixes and visual improvements

Version 2.1

Two types of template formats have been implemented: the fixed one which points to a certain list of objects to be transferred, and the dynamic one which defines only excluded objects; the objects out of this list are to be transferred. Template files of old format are still supported
Added the opportunity to connect through the SSH or HTTP tunnel
The 'Recreate database' option is implemented in the GUI version of the utility: the options allows you to delete the existing database before creating a new one (this option has been only in the console version until now)
Now the console version returns the error code (0 - successful termination, 1 - critical error, 2 – non-critical error)

Version 2.0

Version 1.6

Fixed the "Floating point division by zero" error that arose in some particular cases
MySQL 5.0.1 support
Corrected the maximal length of identifiers: 128 for table names, 30 - for fields and 18 for index (instead of 18 for all)
Some minor visual improvements and bug-fixes

Version 1.4

Implemented Global Type Mapping: now it is possible to set the correspondence between types of the source and the target databases
The utility now shows the import progress indicator for tables and table records; average import speed is also displayed
Now the program correctly recognizes schemas for Oracle data sources
Data Pump now supports MySQL v4.1.1

Version 1.0

Basic features:

Converting database structure and data from any SQL servers or local databases which have an ADO provider
Ability to create a new MySQL database or connect to the existing one
Possibility of selecting source tables, fields and indices for conversion
Easy and customizable generation of MySQL tables, fields and indices according to the source database structure
Ability to view, edit and save SQL script for generating target database to a file
Full monitoring of the generation process
Possibility of selecting tables for data import
Friendly graphical user interface
The command-line utility to generate data using the template file

and more...