Exporting and Importing

Use

You can export application data and the database catalog from a MaxDB database instance, or you can import them into a MaxDB database instance.

Activities

The following table shows which database tools are suitable for which tasks.

Data Transfer

Task

Data Source

Data Target

Database Tool

Exporting application data:

Including LONG columns

In different formats

Converting Date and Time Values

Converting NULL values

Mapping character records

MaxDB database instance

MaxDB database instance

File

Pipe

External data carrier, such as a tape

Loader, Exporting: Commands

Exporting LONG Values

Importing application data:

Including LONG columns

In different formats

Converting date and time formats

Converting NULL values

Mapping character records

MaxDB database instance

File

Pipe

External data carrier, such as a tape

MaxDB database instance

Loader, Importing: Commands

Importing LONG-Values

Export database catalog

MaxDB database instance

MaxDB database instance

File

Pipe

External data carrier, such as a tape

Loader

Importing the database catalog

See above

MaxDB database instance

Loader, Exporting and Importing: Commands (see above)

Exporting application data:

LONG values restricted (only individually or up to a certain length)

MaxDB database instance

File (text or table format)

SQL Studio,

Importing and Exporting LONG Columns

Importing application data:

Restricted LONG values (individually only)

From a script

File

MaxDB database instance

SQL Studio,

Importing and exporting LONG columns (see above)

Importing and exporting SQL statements (see above)

Exporting definitions of database objects

MaxDB database instance

File

SQL Studio, Exporting the Definition of a Database Object

Importing definitions of database objects

File

MaxDB database instance

SQL Studio, Importing and exporting SQL statements (see below)

Exporting SQL statements

MaxDB database instance

File

SQL Studio, Importing and Exporting SQL Statements

Importing SQL statements

File

MaxDB database instance

SQL Studio, see above.

Copying the whole database instance

MaxDB database instance

MaxDB database instance

Database Manager, see Database Copy

See also:

Backing Up and Restoring

Replication and High Availability

Administration