Data Export and Import Tool for MySQL

MySQL data import from 10 commonly used formats

dbForge Studio for MySQL allows to import data from the most popular formats in just a few clicks:

Import to a new table

The tool makes it possible to import data to a different MySQL server connection, different database or schema. You can also import data to a new or existing table.

Customizable import options

You can configure import options according to your needs. Custom settings depend on the selected data import format.

For convenience, you can set a range of rows or columns to be imported.

Configurable data formats

dbForge Studio for MySQL can help introduce and sustain data standards adopted within your organization. For instance, you can adjust the following:

• Null string
• Thousand separator
• Decimal separator
• Date and time format

You can set options for each column separately.

Customizable and automated mapping

Column mapping allows you to configure the way your records should be stored in the target destination for maximum performance and efficiency.

If you are importing data into a new table, the tool will automatically create and map all the columns. If you are importing data into an existing table, the columns with the same names will already be mapped. You can map the rest manually.

Data import modes

With dbForge Studio for MySQL, you can select a data import mode according to the needs of your project:

• Append
• Update
• Append\Update
• Delete
• Repopulate

You can also select to import data in a single transaction.

Data import output

You can configure options to manage the data import script output:

• Open a data import script in the internal editor
• Save your data import script to a file
• Import data directly to the MySQL database

The tool also allows to add a timestamp to the file name automatically and select a required folder to save the file to.

Handling import errors

You can customize error handling behavior and logging options according to the needs of your project. This helps to drastically save time on database development, administration, and maintenance.

Saving import templates

dbForge Studio for MySQL allows to save your import options as a template in order to speed up repetitive data import. You can reuse the templates as many times as you want.

It is also possible to share templates with your teammates to save time and ensure data standardization.