# Bulk import and export

You can use import and export procedures which are executable from ij or any Java program. You must have derbytools.jar in your classpath to use the import or export procedures from ij.

To invoke an import or export procedure, you must be connected to the database into which data is imported or from which data is exported. Because the procedures will issue a COMMIT or a ROLLBACK statement, you should perform either a COMMIT or ROLLBACK to complete all transactions and release all table-level locks prior to invoking the import or export procedure. Other user applications that access the table with a separate connection do not need to disconnect.

Note: Imports are transactional. If an error occurs during bulk import, all changes are rolled back.

- Bulk-Import
- Bulk-Export
- Examples of bulk import and export
- Importing into tables with identity columns
- Executing import/export procedures from JDBC
- File format for input and output
- Treatment of NULLS
- CODESET values for import/export

Parent topic: Using the bulk import and export procedures
Related concepts
Bulk Import/Export overview