Data Export
Features > Data Export
Toad Edge allows you to export various data from Object Explorer, Object Detail and Describe Object and Result Set.
Exporting data from Object Explorer
There are two kinds of exports available in Object Explorer:
- Export Script
- exports the SQL create script for any object
- Export Data
- exports table records
You can export data in SQL (INSERT/MERGE ) or CSV format.
To export script of an object in Object Explorer
- Right-click an object and select Export Script
- Select Destination and configure Script Options
To export table data in Object Explorer
- Right-click a table and select Export Data
- In the first dialog of the wizard, you can Add other tables to the export. If your table is linked to other tables by a relationship, you can also Add Children/Parent tables
- In the next dialog, select the export format and its Destination
- The next dialog presents you with a grid where you can exclude specific data type columns from the export
- If you want to exclude specific columns rather than column data types, you can do so in the following dialog
- The last dialog contains a couple more SQL Settings. Once you are done with the configuration, click Finish
Exporting data from Object Detail and Result Set
There are two kinds of exports available in Object Detail | Data tab and Result Set:
- Export Grid Selection
- exports the rows that you have selected in grid
- Export Query Result
- exports the entire contents of the grid
You can export data in CSV and SQL (INSERT/MERGE statements) format. Grid selection can be additionally exported in HTML and XML format.
To export data from Object Detail or Result Set
- Open a table or a view in Object Detail | Data tab or execute a query to display the Result Set
- Right-click anywhere in the grid and select Export Grid Selection or Export Query Result
- If exporting to XML/HTML, simply choose the destination path and Save the export
- If exporting to CSV/SQL, select the format of the export and its Destination
- In the last dialog, configure the final SQL/CSV Settings to your liking and click Finish
Data Import
Features > Data Import
Importing data is the fastest way to populate your tables. Toad Edge offers data import from SQL (INSERT or MERGE statements) or CSV files. You can even import data from ZIP archives that contain these files.
|
Note: CSV file import currently allows importing data only into one table at a time. |
To import data into a table:
- In Object Explorer, right-click the table you want to import data into and choose Import Data...
- In the Import Data wizard, choose the import file format, the Source path and encoding. The encoding field is editable in case encoding is not detected correctly
- The final dialog depends on whether you import a SQL or a CSV file:
- SQL file - you can configure additional SQL Format Settings, for example, you may want to remove the database name from the code or open it in Worksheet
- CSV file - you can configure various CSV Format Settings such as delimiters, date and time formats...
- Once you are done with the final configuration, click Finish
JSON Support and Editor
Features > JSON Support and Editor
JSON support and JSON Editor
MySQL 5.7 and newer offer support for native JSON (JavaScript Object Notation) data types. With Toad Edge, you can view JSON columns structure clearly in multiple places and you can also edit specific JSON values using an editor with the support of Content Assist, Quick Fixes, and other features.
To view JSON column values
- In Object Explorer, locate your database/schema and then the table that contains a JSON data type column
- Expand the table node, the columns node and then finally the node of the specific JSON column
To view detailed structure of JSON values
- Double-click any table in Object Explorer with a JSON data type column to open it in Object Detail)
- In Object Detail, switch to the Data tab
- Right-click a value and select Define in Editor to open the value in JSON Editor
- The structure of the specific JSON value is then displayed in Outline View
JSON Editor
To edit values in JSON Editor
- Double-click any table in Object Explorer with a JSON data type column to open it in Object Detail)
- In Object Detail, switch to the Data tab
- Open a JSON value in JSON Editor by either:
- Right-clicking the value and selecting Define in Editor
- Double-clicking the value and clicking the edit icon

JSON Editor has two especially notable features:
- Content Assist (CTRL (⌘) + SPACE) - suggests JSON templates (see Templates for more information)
- Quick Fix - offers simple solutions to syntax errors, use them by right-clicking an underlined part of the JSON value and selecting a fix
Management of BLOBs
Features > Management of BLOBs
There are several tools that can be used to work with BLOBs (Binary large objects). You can open them in application of your choice and you can also import/export BLOB values directly in Object Detail.
To view the contents of a BLOB value
- Open a table with BLOB values in Object Detail and switch to the Data tab
- Double-click any BLOB value to open it in its associated application
|
NOTE: The application in which the BLOB value will be opened depends on current settings. See BLOB Viewers |
To export BLOB values
- Open a table with BLOB values in Object Detail and switch to the Data tab
- Right-click any BLOB value and select Export BLOB to File
- Choose the destination for the file and click Save
To import BLOB values
- Open a table with BLOB values in Object Detail and switch to the Data tab
- Right-click any BLOB value and select Import BLOB from File
- Select the file that you would like to import as a BLOB value and click Open
|
NOTE: The imported file must not exceed the maximum size of the destination BLOB column type. The maximum size of a BLOB column value of each type is:
- TINYBLOB - 255 bytes
- BLOB - 64 KB
- MEDIUMBLOB - 16 MB
- LONGBLOB - 4GB
|