Procedure documentationExporting and Importing Locate this document in the navigation structure

Procedure

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