Table of Contents

Search

  1. About the Data Vault Administrator Guide
  2. Introduction to the Data Vault
  3. Data Vault Service Startup and Shutdown
  4. Data Vault Configuration
  5. Data Vault SSL Setup
  6. Data Vault ODBC Setup
  7. Data Vault Administration
  8. Data Repartitioning
  9. Partial Data Vault Copy
  10. Archived Data Migration
  11. Bulk File Uploader
  12. Data Vault Administration Tool
  13. Data Vault Logs
  14. User Account Privileges
  15. ssasql Command Line Program
  16. Data Vault Audit Log
  17. Sample Configuration Files

Data Vault Administrator Guide

Data Vault Administrator Guide

Data Export

Data Export

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:
  1. Connects to the Data Vault server on the source system.
  2. If you use automatic file transfer, the utility connects to the FTP server on the target system.
  3. The utility extracts the metadata structure from the Data Vault repository for the database, schema, or table that you export.
  4. 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.
  5. If you use automatic file transfer, the utility copies the TAR archive file and the data files to the target system.

0 COMMENTS

We’d like to hear from you!