Before you begin, you want to verify how many rows the source TICKET table includes. You run a query to count the rows in the TICKET table. The TICKET table includes 30,000 rows. After you copy the data to the target Data Vault system, you plan to run the same query on the target to confirm that the partial data copy is successful.

The following figures shows an example of the query and the query results:

To export the data, run the following ssadbcopy command in the source system:

ssadbcopy -f -n /u01/sct_stage -r /u01/vtruskov/temp -d LOYALTY -s "LOYALTY_BLOB" -t "TICKET"

The following figure shows the command and the command output:

The utility generated the data export files in the source system directory

/u01/vtruskov/temp

.

The following figure shows the

/u01/vtruskov/temp

directory in the source system:

The utility used an FTP server to copy the data export files to the target system directory

/u01/vtruskov/dbcopy_archive

. The utility copied the data files to the

/u01/sct_stage

directory.

The following figure shows the directories for the data files and TAR archive file in the target system:

All the data export files exist in the target system. Next, import the data in the target system.