Data Vault Administrator Guide

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

Back Next

ssamigrate Example Scenarios

You can run the ssamigrate command with one or more options.

Migrate data from one database: You want to migrate all the data from one database in the source Data Vault system to the target Data Vault system.
Run the following ssamigrate command:
ssamigrate -l cas://atmos_cloud1/ -d RET_LOYALTY -u dba/dba
The utility migrates the data and structure for database RET_LOYALTY. The utility saves the log, report, and runtime files to the
/data/temp
directory on the source system. The utility transfers the SCT data files to the target location
cas://atmos_cloud1/
.
Migrate data from one schema: You want to migrate data from one schema in the source Data Vault location with a local file system to a target Data Vault location with an external storage system.
Run the following ssamigrate command:
ssamigrate -l cas://atmos_cloud1/ -d RET_LOYALTY –s LOYALTY_AIR -u dba/dba
The utility migrates the data and structure for database RET_LOYALTY and schema LOYALTY_AIR. The utility saves the log, report, and runtime files to the
/data/temp
directory on the source system. The utility transfers the SCT data files to the target location
cas://atmos_cloud1/
.
Migrate data from one table: You want to migrate data from one table to the target Data Vault system.
Run the following ssamigrate command:
ssamigrate -l cas://atmos_cloud1/ -d RET_LOYALTY –s LOYALTY_AIR –t TICKET -u dba/dba
The utility migrates the data and structure for database RET_LOYALTY, schema LOYALTY_AIR, and table TICKET. The utility saves the log, report, and runtime files to the
/data/temp
directory on the source system. The utility transfers the SCT data files to the target location
cas://atmos_cloud1/
.

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

ssamigrate Example Scenarios

ssamigrate Example Scenarios