Data Vault Administrator Guide

6.5 HotFix 1
- 6.5.1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Step 1. Migrate the Data from the Source to the Target System

Before you begin, run a query to get the file count and file details of the SCT files for the TICKET table. After you migrate the data to the target Data Vault system, you plan to run the same query on the target to confirm that the migration is successful.

Get the list of tables for the database 123SDBCOPY. From the command prompt, run the following command:

tables

Note the table ID for the TICKET table.

To get the list of files for the TICKET table, run the following command:

files <table ID>

The following image shows the commands and the result:

Note the SCT file count and file details such as row count and file size.

Run the following ssamigrate command in the source system to migrate the data:

ssamigrate -l cas://atmos_cloud1/ -r /data/idvuser/Jenkins_slave/workspace/IDV64.3_SUSILinux64/temp -d 123sdbcopy -s "LOYALTY_BLOB" -t "TICKET" -u dba/dba

The following image shows the command and the result:

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

Step 1. Migrate the Data from the Source to the Target System

Step 1. Migrate the Data from the Source to the Target System