Export Data As Insert Dialog

Export Data As INSERT Dialog allows you to export data from a table or a query result to the SQL script as a number of INSERT statements.

To export data as INSERT from a table

1

Select the table to export data from in the DB Explorer tree (press Ctrl+F for quick searching).

2

Right-click and select the Data Manipulation item from the popup menu.

3

Select the Export Data as INSERT item from the Data Manipulation submenu.

or

1   Open the table to export data from in the Table Editor.

2   Open the Data tab.

3   Click the Export Data as INSERT button on the toolbar.

To export data as INSERT from a query

1

Build a query in the SQL Editor or Visual Query Builder.

2

Execute the query.

3

Open the Results tab.

4

Click the Export Data as INSERT button on the toolbar.

Any of the actions above opens the Export Data As INSERT Dialog.

File Name
Set the name of the result file to export data to.

Table Name
Set the table name to use in the INSERT statements and in the CREATE TABLE statement.

   Add CREATE TABLE statement
Checked option adds the CREATE TABLE statement to the result SQL script with the table name set in Table Name. You can view and edit this statement on the Create Table tab.

Fields Tab

On this tab the list of fields to export is set. All the table fields are included in the 'Included Fields' list by default; if you don't want some fields to be exported, move them back to the 'Available Fields' list. To move the field from one list to another double-click it or select it (use Ctrl or Shift to select multiple fields) and click button > or <. To move all the fields click button >> or <<.

Options Tab

   Replace non-print characters in strings with spaces
Checked option replaces all non-print characters in the result SQL script with spaces.

   Insert 'COMMIT' after each ... records
Defines the number of records, after exporting which the COMMIT statement will be automatically inserted into the result SQL script.

   Load script into Script Editor after export
Checked option loads the created SQL script into the SQL Script Editor after export.

See also:

Export Data Dialog SQL Script Editor Extract Metadata