You want copy data from one database and use an FTP server to automatically export files from the source Data Vault system to the target Data Vault system.

Run the ssadbcopy command with the following options:

ssadbcopy -f -n /u01/sct_stage -r /data/temp -d LOYALTY

The utility exports the data and structure for database name LOYALTY. The utility saves the data export files to the

/data/temp

directory on the source system. The utility uses an FTP server to transfer the data files and the data export files to the Data Vault target system. The utility transfers the data files to the

/u01/sct_stage

directory on the Data Vault target system. The utility transfers the data export files to the location that you configured in the FTP ini.file.

You want to copy data from one table and manually export files from the source Data Vault system to the target Data Vault system.

Run the ssadbcopy command with the following options:

ssadbcopy -n /u01/sct_stage -r /data/temp -d LOYALTY –s LOYALTY_AIR –t TICKET

The utility exports the data and structure for database LOYALTY, schema LOYALTY_AIR, table TICKET. The utility saves the data export files to the

/data/temp

directory on the source system. You transfer the SCT data files to the

/u01/sct_stage

directory on the Data Vault target system. You also transfer the data export files to a temporary directory on the Data Vault target system.

Run the ssadbcopy command with the following options:

ssadbcopy -n cas://2_ssadbcopy_test/ -t LINEITEM -s TPC_H -d SDS -r /u01/IDV642_Lin64/temp -l /u01/IDV642_Lin64/temp -u dba/dba

The utility exports the data and structure for database SDS, schema TPC_H, table LINEITEM. The utility saves the data export files to the

/u01/IDV642_Lin64/temp

directory on the source system. You must manually transfer the SCT data files to the

/u01/IDV642_Lin64/temp

directory on the external storage system. You also transfer the data export files to a temporary directory in the external storage file system.