Show TOC

Transporting Data and/or Information from the Database CatalogLocate this document in the navigation structure

Context

You transport application data and/or the information from the database catalog to a different SAP MaxDB database or to a different schema or user in the same database. If you perform transports between different databases, the databases can run on different operating systems and on different hardware architectures.

Note

The following text describes the transport options in the context menus of Database Studio. You can also use drag and drop in the explorer tree to transport databases, users, schemas, and tables.

Procedure

  • Transporting Databases

    Prerequisites

    • The source and the target databases are in the ONLINE operational state.

    • You are logged on to the source and target databases as the database system administrator.

    Procedure

    1. Select the source database in the explorer tree.

    2. In the context menu of the database, choose Start of the navigation path Export/Import Next navigation step Transport... End of the navigation path.

    3. In the target database, select the database system administrator.

    4. Select your transport options.

      Property

      Description

      Transport catalog

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

      Transport data

      The application data from the selected tables is transported.

    5. Select the tables that you want to transport.

      Note

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

    6. To start the transport, choose Finish.

    Result

    After the import, the passwords of all imported users are reset to INITIAL. Assign new passwords after the import.

  • Transporting the Database Objects of Users

    Prerequisites

    • The source and the target databases are in the ONLINE operational state.

    • In the source database, a Database Studio login for the user whose objects you want to transport has been created.

    Procedure

    1. In the explorer tree, select the user of the source database whose database objects you want to transport.

    2. In the context menu of the user, choose Start of the navigation path Export/Import Next navigation step Transport... End of the navigation path.

    3. In the target database, select the user who is to own the transported database objects.

    4. Select your transport options.

      Property

      Description

      Transport catalog

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

      Transport data

      The application data from the selected tables is transported.

    5. Select the tables that you want to transport.

      Note

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

    6. To start the transport, choose Finish.

  • Transporting Schemas

    Prerequisites

    • The source and the target databases are in the ONLINE operational state.

    • You are logged on to the source database as the database user who is the owner of the schema and to the target database as the database user who is going to own the transported schema.

    Procedure

    1. In the explorer tree, select the schema whose database objects you want to transport.

    2. In the context menu of the schema, choose Start of the navigation path Export/Import Next navigation step Transport... End of the navigation path.

    3. In the target database, select the user who is to own the transported schema.

    4. Select your transport options.

      Property

      Description

      Target schema name

      Select the target schema name. To create a new schema, select <NEW SCHEMA> and enter the name of the new schema.

      Transport schema catalog

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

      Transport schema data

      The application data from the selected tables is transported.

      Exclude tables from data transport

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

      Recreate existing schema

      Add to existing schema

      Choose how to proceed if the selected schema already exists in the target database.

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

      Note

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

    6. To start the transport, choose Finish.

  • Transporting Tables

    Prerequisites

    • The source and target databases are in the ONLINE operational state.

    • You are logged on to the source database as a database user who is authorized to access the tables that you want to transport, and to the target database as a database user who can create tables.

    Procedure

    1. In the explorer tree, select the table in the source database that you want to transport.

    2. In the context menu of the table, choose Start of the navigation path Export/Import Next navigation step Transport... End of the navigation path.

    3. In the target database, select the user who is to own the transported table.

    4. Select your transport options.

      Property

      Description

      Target schema name

      Select the target schema name. To create a new schema, select <NEW SCHEMA> and enter the new schema name.

      Transport catalog

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

      Transport data

      The application data from the selected table is transported.
      Note

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

    5. To start the transport, choose Finish.

Next Steps

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