Import

Enable the Database Tools and SQL plugin

This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in IntelliJ IDEA by default. If the relevant features are not available, make sure that you did not disable the plugin.

1. Press Ctrl+Alt+S to open settings and then select Plugins.

2. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name.

Import data

1. In the Database tool window ( View | Tool Windows | Database) , right-click a data source, or a schema and select SQL Scripts | Run SQL Script.

   

2. In the file browser window that opens, navigate to the SQL file that you want to run.

3. Click Open.

   You can view the output in Run tool window. For more information about tool window controls, refer to Run tool window.

Import data from CSV files

IntelliJ IDEA uses data extractors to import data from CSV files. For more information about data extractors, refer to the Data extractors topic.

1. 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).

2. Navigate to the CSV files and select them.

3. In the mapping tree of Import dialog, select the mapping node () and specify the data conversion settings.

   You can select in which 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 Schema and Table fields.

4. In the mapping tree, select the source file to configure its settings. To mark the first row as a header, select First row is header.

5. Apply the changes and close the dialog.

Import data from tabular data files

IntelliJ IDEA uses scripted data loaders to import data from tabular data files. For more information about scripted data loaders, refer to the Data loaders topic.

1. 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).

2. Navigate to the tabular data files and select them.

3. In the mapping tree of Import dialog, select the mapping node () and specify the data conversion settings.

   You can select in which 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 Schema and Table fields.

4. In the mapping tree, select the source file to configure its settings. To mark the first row as a header, select First row is header.

5. Apply the changes and close the dialog.

Import tables

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

2. Open the Import dialog. To do that, 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.

3. In the mapping tree of Import dialog, select the mapping node () and specify the data conversion settings.

   You can select in which 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 Schema and Table fields.

4. In the mapping tree, select the source file to configure its settings.

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

6. Apply the changes and close the dialog.

Restore Microsoft SQL Server table data

You can restore a Microsoft SQL Server table data by using the bcp utility. The tool is not integrated into IntelliJ IDEA. You can read about it at learn.microsoft.com.

1. In the Database tool window ( View | Tool Windows | Database) , right-click the table that you want to import your data to and select Import/Export | Restore with 'bcp'.

2. In the Restore with bcp (<data_source_name>) dialog, specify the path to the bcp executable in the Path to bcp field.

3. In the Source file, specify the path to the file that you want to restore the data from.

4. Click Run.