Show TOC

Exporting Data and/or Information from the Database CatalogLocate 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 Start of the navigation path Export/Import Next navigation step Export... End of the navigation path.

    3. Select your export options.

      Property

      Description

      Export catalog

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

      Export 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

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

    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 Start of the navigation path Export/Import Next navigation step Export... End of the navigation path.

    3. Select your export options.

      Property

      Description

      Export catalog

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

      Export 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

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

    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 Start of the navigation path Export/Import Next navigation step Export... End of the navigation path.

    3. Select your export options.

      Property

      Description

      Export catalog

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

      Export 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

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

    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 Start of the navigation path Export/Import Next navigation step Export... End of the navigation path.

    3. Select your export options.

      Property

      Description

      Export catalog

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

      Export 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.

Results

Default export directories:

  • Microsoft Windows:

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

    Example

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

  • Unix and Linux:

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

The logical package structure is displayed under Start of the navigation path My Repository Next navigation step Packages End of the navigation path.

  • 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).

Next Steps

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