Import

In the Database tool window ( View | Tool Windows | Database), right-click a data source.

Select SQL Scripts | Run SQL Script….

In the file browser, navigate to the SQL file that you want to apply.

In the Database tool window ( View | Tool Windows | Database), right-click a schema or a table and select Import/Export | Import Data from File(s).

Navigate to the file that contains delimiter-separated values and double-click it.

In the Import "file_name" File dialog, specify the data conversion settings and click Import.

You can select in what schema to create a table and whether to import data to a new table or an existing one. To select a schema or a table, use Table and Target schema lists.

To mark the first row as a header, right-click the row in the Data Preview pane and select First Row Is Header.

In the Database tool window ( View | Tool Windows | Database), right-click a schema or a table and select Import/Export | Import Data from File(s).

Navigate to the files that contain delimiter-separated values, select them, and click Open.

In the Import "file_name" File dialog, specify the data conversion settings for every file. You can go through the files in the Sources pane. Click Import to import the files.

You can select in what schema to create a table and whether to import data to a new table or an existing one. To select a schema or a table, use Table and Target schema for all sources lists.

To mark the first row as a header, right-click the row in the Data Preview pane and select First Row Is Header.

Select tables that you want to copy to a different schema, database, or existing table.

Open the Import 'table_name' Table dialog. To open the Import 'table_name' Table dialog, you can use the following actions:

• Right-click the selection and navigate to Import/Export | Copy Tables to....

• Drag the selection to a schema or a database.

• Press Ctrl+Shift+A, type copy tables to and press Enter.

From the Target schema for all sources list, select a schema in which you want to create a table. In case of a single table, this menu item is called Target schema.

In the Table list, type a name of a new table or select an existing table to add data to the selected table.

In the Sources list, click tables that you want to configure.

(Optional) Click the Add icon () to add columns, keys, and indexes.

(Optional) Select Insert inconvertible values as null if you want to insert NULL when the IDE meets an inconvertible value.

Select Disable indexes and triggers, lock table (may be faster) if you want to disable indexes and triggers during the import. Note that if you selected this option, it might lead to a situation when a trigger does not fire and fails to pass its results. Though it might improve the performance of the importing process. The option is available only when the target table (to which you copy values) has indexes or triggers.

Click Import.