Background documentationTransport Locate this document in the navigation structure

 

The following are some examples of data transports (export with subsequent import) where the Loader CLI is in transport mode.

Prerequisites

You require the demo databases DEMODB and TESTDB. Start the Loader in transport mode: loadercli -p.

You do not require and knowledge about the Loader syntax in transport mode. The generated Loader commands are, however, displayed on the console and in the Loader files, and can be used as templates for writing your own Loader commands.

Activities

Executing Transports

You want to transport the database catalog and the application data of the HOTEL schema for database user MONA between databases DEMODB and TESTDB.

loadercli -p

Package history: C:\Documents and Settings\anna\Application Data\sdb\loader\log\transport.log

Package path: c:\transport

Package name : 20060302090909

Step 1: Enter a package path

Package path: c:\transport

Step 2: Enter a package comment

Package comment: transport

Step 3: What do you want to do?

[1] Transport from a source database to a target database

[2] Export from a source database

[3] Import to a target database

Step 3: 1

Step 4: What do you want to do?

[1] Choose a transport package

[2] Create a transport package

Step 4:2

Step 5: Enter the source database connection

Database computer : genua

Database name : demodb

Database user : mona

Password : red

Step 6: Enter the target database connection

Database computer : genua

Database name : testdb

Database user : mona

Password : red

Step 7: Choose what you want to include in the package

[1] Complete user

[2] Complete user excluding some tables

[3] Complete schema

[4] Complete schema excluding some tables

[5] Schema tables

Step 7: 1

Step 8: Choose the transformation streams

[1] Catalog and data

[2] Catalog

[3] Data

Step 8: 1

Step 9: The package can be executed or generated now.

[1] Execute package to transport data now

[2] Generate package to execute it later

Step 9: 1

Transport package name : 20060302090909

Transport package comment : transport

Transport package creation : 20060302090909

Transport package execution : 20060302090909

Transport package path : c:\transport

Transport package status [-T]: EXECUTE

Transport direction [-t]: TRANSPORT

Transport package [-p]: USER

Transport part  [-P]: USER

Transport streams [-s]: CATALOG,DATA,PACKAGE

Transport format [-f]: RECORDS

Transport format [-F]: ROW

Transport encoding [-c]:

Transport lobcolumn [-l]: TABLE

Source database computer [-nSRC]: GENUA

Source database name [-dSRC]: DEMODB

Source database user [-uSRC]: MONA

Target database computer [-nTRC]: GENUA

Target database name [-dTRC]: TESTDB

Target database user [-uTRC]: MONA

Step 10: Continue

[1] OK

[2] CANCEL

Step 10: 1

EXPORT USER

CATALOG OUTSTREAM PIPE 'MONA.CATALOG' DDL

DATA  OUTSTREAM PIPE 'MONA.DATA' RECORDS

  ;

IMPORT USER UPDATE DUPLICATES

CATALOG STREAM PIPE 'MONA.CATALOG' DDL

DATA     INSTREAM PIPE 'MONA.DATA' RECORDS

  ;

Package execution time   : 11.625s

Package execution log : loader_20060302090909

Package name : 20060302090909

You can see the Loader commands that are processed when transport package 20060302090909 is executed in log file loader_20060302090909.log .

Repeating Transports

If you would like to repeat the transport you just executed in transport mode, specify the name of the transport package when you call the Loader CLI:

loadercli -p 20060302090909

Step 1: Enter the source database connection

Database computer : genua

Database name : demodb

Database user : mona

Password : red

Step 2: Enter the target database connection

Database computer : genua

Database name : testdb

Database user : mona

Password : red

Transport package name : 20060302090909

Transport package comment : transport

Transport package creation : 20060302090909

Transport package execution : 20060302101010

Transport package path : c:\transport

Transport package status [-T]: EXECUTE

Transport direction [-t]: TRANSPORT

Transport package [-p]: USER

Transport format [-f]: RECORDS

Transport format [-F]: ROW

Transport part  [-P]: USER

Transport streams [-s]: CATALOG,DATA,PACKAGE

Transport encoding [-c]:

Transport lobcolumn [-l]:

TABLE Source database computer [-nSRC]: GENUA

Source database name [-dSRC]: DEMODB

Source database user [-uSRC]: MONA

Target database computer [-nTRC]: GENUA

Target database name [-dTRC]: TESTDB

Target database user [-uTRC]: MONA

EXPORT USER

CATALOG OUTSTREAM PIPE 'MONA.CATALOG' DDL

DATA  OUTSTREAM PIPE 'MONA.DATA' RECORDS

  ;

IMPORT USER UPDATE DUPLICATES

CATALOG STREAM PIPE 'MONA.CATALOG' DDL

DATA     INSTREAM PIPE 'MONA.DATA' RECORDS

  ;

Package execution time   : 6.953s

Package execution log : loader_20060302101010

Package name : 20060302090909

You can see the Loader commands that are processed when transport package 20060302090909 is executed in log file loader_20060302101010.log .

Generating a Transport Package

If you want to generate a transport package without executing it, proceed as follows:

loadercli -p

Package history: C:\Documents and Settings\anna\Application Data\sdb\loader\log\transport.log

Package path: c:\transport

Package name : 20060302141414

Step 1: Enter a package path:

Package path:c:\transport

Step 2: Enter a package comment

Package comment: transport_generate

Step 3: What do you want to do?

[1] Transport from a source database to a target database

[2] Export from a source database

[3] Import to a target database

Step 3: 1

Step 4: What do you want to do?

[1] Choose a transport package

[2] Create a transport package

Step 4: 2

Step 5: Enter the source database connection

Database computer : genua

Database name : demodb

Database user : mona

Password : red

Step 6: Enter the target database connection

Database computer : genua

Database name : testdb

Database user : mona

Password : red

Step 7: Choose what you want to include in the package

[1] Complete user

[2] Complete user excluding some tables

[3] Complete schema

[4] Complete schema excluding some tables

[5] Schema tables

Step 7: 1

Step 8: Choose the transformation streams

[1] Catalog and data

[2] Catalog

[3] Data

Step 8: 1

Step 9: The package can be generated or executed now.

[1] Execute package to transport data now

[2] Generate package to execute it later

Step 9: 2

Transport package name : 20060302141414

Transport package comment : transport_generate

Transport package creation : 20060302141414

Transport package execution : 20060302141414

Transport package path : c:\transport

Transport package status [-T]: GENERATE

Transport direction [-t]: TRANSPORT

Transport package [-p]: USER

Transport part  [-P]: USER

Transport streams [-s]: CATALOG,DATA,PACKAGE

Transport format [-f]: RECORDS

Transport format [-F]: ROW

Transport encoding [-c]:

Transport lobcolumn [-l]:

TABLE Source database computer [-nSRC]: GENUA

Source database name [-dSRC]: DEMODB

Source database user [-uSRC]: MONA

Target database computer [-nTRC]: GENUA

Target database name [-dTRC]: TESTDB

Target database user [-uTRC]: MONA

Step 9: Continue

[1] OK

[2] CANCEL

Step 9: 1

EXPORT USER

CATALOG OUTSTREAM PIPE 'MONA.CATALOG' DDL

DATA  OUTSTREAM PIPE 'MONA.DATA' RECORDS

  ;

IMPORT USER UPDATE DUPLICATES

CATALOG STREAM PIPE 'MONA.CATALOG' DDL

DATA     INSTREAM PIPE 'MONA.DATA' RECORDS

  ;

Package execution time   : 8.484s

Package name : 20060302141414

Executing a Generated Transport Package

If you would like to execute the generated transport information in transport mode, specify the name of the transport package when you call the Loader CLI:

loadercli -p 20060302141414

Step 1: Enter the source database connection

Database computer : genua

Database name : demodb

Database user : mona

Password : red

Step 2: Enter the target database connection

Database computer : genua

Database name : testdb

Database user : mona

Password : red

Transport package name : 20060302141414

Transport package comment : transport_generate

Transport package creation : 20060302141414

Transport package execution : 20060302151515

Transport package path : c:\transport

Transport package status [-T]: EXECUTE

Transport direction [-t]: TRANSPORT

Transport package [-p]: USER

Transport part  [-P]: USER

Transport streams [-s]: CATALOG,DATA,PACKAGE

Transport format [-f]: RECORDS

Transport format [-F]: ROW

Transport encoding [-c]:

Transport lobcolumn [-l]:

TABLE Source database computer [-nSRC]: GENUA

Source database name [-dSRC]: DEMODB

Source database user [-uSRC]: MONA

Target database computer [-nTRC]: GENUA

Target database name [-dTRC]: TESTDB

Target database user [-uTRC]: MONA

EXPORT USER

CATALOG OUTSTREAM PIPE 'MONA.CATALOG' DDL

DATA  OUTSTREAM PIPE 'MONA.DATA' RECORDS

  ;

IMPORT USER UPDATE DUPLICATES

CATALOG STREAM PIPE 'MONA.CATALOG' DDL

DATA     INSTREAM PIPE 'MONA.DATA' RECORDS

  ;

Package execution time   : 6.781s

Package execution log : loader_20060302151515

Package name : 20060302141414

You can see the Loader commands that are processed when transport package 20060302141414 is executed in log file loader_20060302151515.log .