Online Documentation for Data Pump for MySQL

EMS Data Pump FAQ

Please read this page attentively if you have questions about EMS Data Pump for MySQL.


Table of contents


Question/answer list


Q: What is EMS Data Pump?

A: Data Pump for MySQL is an excellent utility for converting databases and importing table data from any ADO-compatible source (e.g. MS Access or any other database with ADO support) to MySQL databases. The easy-to-use wizard application allows you to build the ADO connection string, select the source tables, fields, indices and constraints for converting, view and edit the SQL script for generating target MySQL database, select tables to be imported and customize a number of pump options.


Q: What do I need to start working with EMS Data Pump?

A: First of all, you must have a possibility to connect to some local or remote MySQL server to work with Data Pump. You can download MySQL database server from Besides, you need your workstation to satisfy the system requirements of Data Pump for MySQL.


Q: What is the easiest way to configure the template files for the MySQL Data Pump console application?

A: You can configure the template files visually using the MySQL Data Pump wizard. Set the required   pump options at of the wizard, click the 'Tools' button and select the 'Save Template' popup menu item. All the options will be saved to the template file which can be used later in the console application.


Q: How can I register the product?

A: If you have already purchased Data Pump for MySQL, you can register the product by entering the appropriate registration information. Please refer to Registration and How to register EMS Data Pump for details.


Q: Are there any limitations implied in the trial version as compared with the full one?

A: The trial version of the utility admits to the maximum of 10% of records to be imported for each table. In all other respects it does not differ from the full version as far as the functionality is concerned. That is, you can test all the features implemented in Data Pump for MySQL within the 30-day trial period.


Q: I’m trying to import data from MS Access. When I expand a table node, it shows indices(0), constraints(0) and I cannot select them. How can I fix this?

A: The solution to this problem is to use the Microsoft Jet OLE DB Provider for establishing connection to your source Access database.


Scroll to top


If you have any additional questions, contact us at our Support Center.