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

 

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

End of the note.

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   Export/Import   Transport...  .

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

  4. Select your transport options.

    Options for Transporting Databases

    Property

    Description

    Transport table definition

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

    Transport table data

    The application data from the selected tables is transported.

  5. Select the tables that you want to transport.

    Note Note

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

    End of the note.
  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   Export/Import   Transport...  .

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

  4. Select your transport options.

    Options for Transporting the Database Objects of Users

    Property

    Description

    Transport table definition

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

    Transport table data

    The application data from the selected tables is transported.

  5. Select the tables that you want to transport.

    Note Note

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

    End of the note.
  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   Export/Import   Transport...  .

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

  4. Select your transport options.

    Options for Transporting Schemas

    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 Note

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

    End of the note.
  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   Export/Import   Transport...  .

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

  4. Select your transport options.

    Options for Transporting Tables

    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 table definition

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

    Transport table data

    The application data from the selected table is transported.

    Note Note

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

    End of the note.
  5. To start the transport, choose Finish.

More Information

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