Transport

Below are just a few examples of transporting data (export followed by an import) when the Loader CLI is in transport mode.

Prerequisites

For a description of the prerequisites, see Transport Mode.

Execute Transport

You want to transport the database catalog and the application data of the HOTEL schema of 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 into a target database
[2] Export from a source database
[3] Import into 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 include into 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  INSTREAM 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 .

Repeat Transport

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 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  INSTREAM 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 current 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 into a target database
[2] Export from a source database
[3] Import into 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 include into 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  INSTREAM 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  INSTREAM 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 current log file loader_20060302151515.log .

See also:

Exporting

Importing

Command File Mode

Session Mode

Loader, Log File