When you export data from the source Data Vault system, you specify the data that you want to copy. You run the ssadbcopy command line utility to export the data. The utility creates data export files that contain DDL and administrator scripts. You transfer the data export files to the target Data Vault system manually or automatically with an FTP server.
When you run the ssadbcopy command for data export, the utility performs the following high-level steps:
Connects to the Data Vault server on the source system.
If you use automatic file transfer, the utility connects to the FTP server on the target system.
The utility extracts the metadata structure from the Data Vault repository for the database, schema, or table that you export.
The utility generates data export files.
The files include DDL and Data Vault administrator scripts that re-create the identical structure on the target. The utility saves the files in a temporary file location on the source system.
If you use automatic file transfer, the utility copies the TAR archive file and the data files to the target system.