Exporting and Importing

The primary tools for exporting and importing are Database Studio and Loader.

Which Database Tools Are Suitable for Export and Import?
Task	Source	Target	Database Tools
Exporting application data: Including LOB columns In different formats Converting date and time values Converting NULL values Mapping character records	Database	Database File Pipe External data carrier, such as a tape	Database Studio, Exporting Data or the Database Catalog Loader, Exporting: Loader Commands Exporting LOB Values
Importing application data: Including LOB columns In different formats Converting date and time formats Converting NULL values Mapping character records	Database File Pipe External data carrier, such as a tape	Database	Database Studio, Importing Data or the Database Catalog Loader, Importing: Loader Commands Importing LOB-Values
Exporting database catalog	Database	Database File Pipe External data carrier, such as a tape	Database Studio Loader
Importing the database catalog	Database File Pipe External data carrier, such as a tape	Database	Database Studio Loader
Exporting SQL statements Exporting definitions of database objects	Database	File	Database Studio, Saving SQL Statements or Definitions of Database Objects in a Repository
Importing SQL statements Importing definitions of database objects	File	Database	Database Studio, Editing Objects in a Repository
Copying the whole database	Database	Database	Database Studio Database Manager More information: Database Copy