Exporting Data

Export data to other formats

To export data to other formats, follow the steps:

1. Open the Data Export wizard by doing either of these actions:

  • On the Start > Data Pump page, click Export Data .
  • In Database Explorer, right-click a table or a view (or CTRL+click several tables and/or views) you want to export data from and select Export Data on the shortcut menu.
  • Right-click the data grid and choose Export Data on the shortcut menu, or click Export Data on the Data Editor window toolbar.
  • On the Database menu, click Export Data.

    Note

    The appearance of the Data Export Wizard can differ depending on a product you use.

2. In the Export format tab, select an export format or load export options from a template file if you saved them previously and click Next.

3. In the Source tab, select a required MySQL server connection, a database, table(s), view(s), which you want to export, and then click Next.

Note

If you opened the wizard from the data grid, the Source tab would allow to specify a name and a path of the destination file (the one where the exported data will be saved.

4. In the Output settings tab, set output options for the exported data and then click Next.

  • Indicate the folder where the exported data will be stored.
  • Select where to export the data: to separated files or to a single file. If selected Export data into single file, specify a name for the file in the File name field.
  • (Optional) Select the Append timestamp to the file name option to add date-time parameters to the file name.

5. In the Options tab, set additional settings for the selected export format and click Next.

6. In the Data formats tab, select exported columns and click Next. (For CSV, HTML, PDF, RTF, and Text export formats, select formats of data representation, e.g., integer, date, time, etc. For Excel and Excel 2007 formats, the field is editable only for binary columns and includes two data types (HexString and String) in the drop-down list).

7. In the Exported rows tab, select exported rows. You can export all rows, selected in the grid ones, or a specified range.

8. In the Error handling tab, do the following:

  • Specify how the application should behave when an error is encountered
  • Optional: Define a log file to write an error report. To do this, select Write a report to a log file.

9. (Optional) To export options to a template file for future usage, click Save > Save Template and specify a path and a name of the template file.

10. (Optional) To export data through the command line, click Save > Save Command Line. For more information about how to export data using the command line, see Export Data through Command Line.

11. To launch the export, click Export and see the result of export process.

12. Select whether to open the exported file or result folder, and click Finish. Data export is finished.

Filtered data export

You can export filtered data in the following ways:

  • in the Data Export wizard
  • using a column filter
  • in the query

Filtering data in the Data Export wizard

There is a filter in the Data Export > Source dialog tab.

Filtering the data export

Filtering data in the column

To filter data in the column, follow the steps:

  1. In the SQL document, write the SELECT * FROM statement.
  2. To execute the query, click Execute.
  3. On the name of the column you want to filter, click the Filter iconfilter icon.
  4. In the drop-down list, choose the item to filter by.
  5. Right-click the filtered grid and select Export Data to call the Data Export wizard.
  6. Follow the Export data to other formats procedure. If the data export is finished successfully, the Data export complete message appears.

Filtering data in the query

To filter exported data directly in the query, follow the steps:

  1. Execute the SELECT * FROM statement with the WHERE condition, where you can specify the required filter.
  2. Right-click the filtered grid and select Export Data from the shortcut menu.

  3. Follow the Export data to other formats procedure. If the data export is finished successfully, the Data export complete message appears.