Online Documentation for SQL Management Studio for MySQL

Running Data Pump

EMS Data Pump for MySQL is an excellent utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access or any other database with ADO support) to MySQL databases. Database conversion becomes as easy as possible with Data Pump for MySQL!

Data Pump for MySQL provides you with an easy-to-use Wizard that guides you through all the steps of the migration process: you can build the connection string, select tables, fields and indices for converting, view and edit the SQL script for generating the target MySQL database structure and select tables for data import.

In addition to the GUI version, which is implemented as a Wizard application, Data Pump for MySQL includes a console version intended to run from the Windows command line with a template file name used as the execution parameter.

To run Data Pump for MySQL, click its icon or caption in the Data Manipulation section and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu, where you can specify a template and then run the wizard/console with the template.

To manage configuration files (templates), use the corresponding Manage templates link. In this case, you will be redirected to the Template Management section of SQL Studio.