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.
- What is EMS Data Pump?
- What do I need to start working with EMS Data Pump?
- What is the easiest way to configure the template files for the Data Pump console application?
- How can I register the product?
- Are there any limitations implied in the trial version as compared with the full one?
- 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: 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.
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 http://www.mysql.org/downloads/. Besides, you need your workstation to satisfy the system requirements of Data Pump for MySQL.
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.
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.
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.
A: The solution to this problem is to use the Microsoft Jet OLE DB Provider for establishing connection to your source Access database.
If you have any additional questions, contact us at our Support Center.