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.
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.
Select the source database in the explorer tree.
In the context menu of the database, choose
.In the target database, select the database system administrator.
Select your transport options.
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. |
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.
To start the transport, choose Finish.
After the import, the passwords of all imported users are reset to INITIAL. Assign new passwords after the import.
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.
In the explorer tree, select the user of the source database whose database objects you want to transport.
In the context menu of the user, choose
.In the target database, select the user who is to own the transported database objects.
Select your transport options.
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. |
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
To start the transport, choose Finish.
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.
In the explorer tree, select the schema whose database objects you want to transport.
In the context menu of the schema, choose
.In the target database, select the user who is to own the transported schema.
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. |
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.
To start the transport, choose Finish.
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.
In the explorer tree, select the table in the source database that you want to transport.
In the context menu of the table, choose
.In the target database, select the user who is to own the transported table.
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 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
You can only transport tables that contain application data. You cannot transport system tables or view tables.
To start the transport, choose Finish.
For a detailed description of all prerequisites and options, see the Loader documentation: Loader Commands and SQL Statements.