Procedure documentationExporting Data and/or Information from the Database Catalog Locate this document in the navigation structure

Procedure

Exporting Databases
Prerequisites

  • The database is in the ONLINE operational state.

  • You are logged in to the database as the database system administrator.

Procedure

  1. Select the database in the explorer tree.

  2. In the context menu of the database, choose   Export/Import   Export...  .

  3. Select your export options.

    Options for Exporting Databases

    Property

    Description

    Export table definition

    The table definitions of the selected tables from the database catalog are exported.

    Export table data

    The application data from the selected tables is exported.

    Format

    Export format

    More information: Loader, PAGES, RECORDS

    Details

    • Package root path

    Directory where the system stores the export data.

  4. Select the tables that you want to export.

    Note Note

    You can only export tables that contain application data. You cannot export system tables or view tables.

    End of the note.

  5. To start the export, choose Finish.

Exporting the Database Objects of Users
Prerequisites

  • The database is in the ONLINE operational state.

  • A Database Studio login has been created for the user whose database objects you want to export.

  • To export tables in PAGES format, the user must be the owner of the tables.

Procedure

  1. Select the user in the explorer tree.

  2. In the context menu of the user, choose   Export/Import   Export...  .

  3. Select your export options.

    Options for Exporting the Database Objects of Users

    Property

    Description

    Export table definition

    The table definitions of the selected tables from the database catalog are exported.

    Export table data

    The application data from the selected tables is exported.

    Format

    Export format

    More information: Loader, PAGES, RECORDS

    Details

    • Package root path

    Directory where the system stores the export data.

  4. Select the tables that you want to export.

    Note Note

    You can only export tables that contain application data. You cannot export system tables or view tables.

    End of the note.

  5. To start the export, choose Finish.

Exporting Schemas
Prerequisites

  • The database is in the ONLINE operational state.

  • You are logged in to the database as the database user who is the owner of the schema.

  • To export tables in PAGES format, the logged in user must be the owner of the tables.

Procedure

  1. In the explorer tree, select the schema that you want to export.

  2. In the context menu of the schema, choose   Export/Import   Export...  .

  3. Select your export options.

    Options for Exporting Schemas

    Property

    Description

    Export table definition

    The table definitions of the selected tables from the database catalog are exported.

    Export table data

    The application data from the selected tables is exported.

    Exclude tables from data export

    Choose this option if you want to exclude tables from the export in the next step.

    Format

    Export format

    More information: Loader, PAGES, RECORDS

    Details

    • Package root path

    Directory where the system stores the export data.

  4. If you chose Exclude tables from data export in the previous step, now deselect the tables that you do not want to export.

    Note Note

    You can only export tables that contain application data. You cannot export system tables or view tables.

    End of the note.

  5. To start the export, choose Finish.

Exporting Tables
Prerequisites

  • The database is in the ONLINE operational state.

  • You are logged in to the database as a database user who is authorized to access the tables that you want to export.

  • The table that you want to export contains application data. You cannot export system tables or view tables.

  • To export a table in PAGES format, the logged in user must be the owner of the table.

Procedure

  1. In the explorer tree, select the table that you want to export.

  2. In the context menu of the table, choose   Export/Import   Export...  .

  3. Select your export options.

    Options for Exporting Tables

    Property

    Description

    Export table definition

    The table definitions of the selected table from the database catalog are exported.

    Export table data

    The application data from the selected table is exported.

    Format

    Export format

    Details

    • Package root path

    Directory where the system stores the export data.

  4. To start the export, choose Finish.

Result

Default export directories:

  • Microsoft Windows:

    <user_home>\sdb\loader\packages\export\<computer_name>\<database_name>\<time_stamp>\

    Example Example

    C:\Users\anna\sdb\loader\packages\export\PARMA\DEMODB\20061220093349\

    End of the example.

  • Unix and Linux:

    <user_home>/.sdb/loader/packages/export/<computer_name>/<database_name>/<time_stamp>/

The logical package structure is displayed under   My Repository   Packages  .

  • To display the properties of a package, choose Properties in the context menu of the package.

  • To execute the export again using an existing package definition, choose Execute in the context menu of the package.

    Note that the new export data overwrites the old export data, but the package name is not changed (it still contains the old timestamp).

More Information

For a detailed description of all prerequisites and options, see the Loader documentation: Exporting: Loader Commands.