You can copy table data to the clipboard or save it in a file. The data is converted into one of the available output formats. As an output format, you can select SQL
UPDATE statements, TSV or CSV, an HTML table or JSON data.
Also, you can create a copy of a table in the schema of the current data source or select another data source and create a copy here.
Export a table to a file
Open a table or a result set, click the Export Data icon () and click Export To File.
Export a table to a clipboard
On the toolbar, click the Export Data icon () and select Copy To Clipboard.
Configure data output format and options
You can configure how extracted data is converted into text using predefined output formats, customized formats, and scripts. To configure the output for extracted data, right-click any cell in the table and select Choose Data Extractor.
In this menu, you can select the output format (for example, as SQL
INSERT statements, HTML table, or in CSV format) or a script that converts data into a specific format.
Additionally, you can configure the following parameters:
Configure CSV Formats. Opens the CSV Formats dialog that you can use to manage your delimiter-separated values formats (for example, CSV or TSV).
Go to Scripts Directory. Opens a directory with the scripts that convert table data into various output formats.
Export data to a database
Make sure that the database is added as a data source in the Database tool window.
Right-click any cell in the table and then click Export to Database.
Specify the database, target schema (to create a new table with the exported data) or table (to add exported data to an existing table).
Configure the data mapping and settings for the target table.