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

TAR Archive File

TAR Archive File

The TAR archive includes a set of SQL, DDL, and administrator scripts. The scripts contain information on the data and structure export. You use the scripts to import the data in the target system. The utility generates the scripts based on the command arguments that you specify.
The TAR archive file includes the following files:
idvmeta_sctlist_target.txt
Text file that includes a list of all required data files for the target system. When you import the data in the target, the ssadbcopy utility validates that all of the data files in the text file exist on the target.
idvmeta.sql
SQL script that creates the database on the target system if the database does not already exist.
idvmeta.ddl
DDL script that contains the DDL structure of the data that you want to extract. When you import the data, the script replicates the source structure on the target. The script creates the schemas, domains, and tables on the target system.
idvmeta_regtable.adm
Data Vault administrator script that registers tables in the Data Vault repository on the target system.
idvmeta_regsct.adm
Data Vault administrator script that registers data files in the Data Vault repository on the target system. To register the data files, the script uses the target data file location that you provide in the ssadbcopy command.
idvmeta_unregtable.adm
Data Vault administrator script that unregisters tables on the target system. The utility uses the script if you import data in drop and create mode.
idvmeta_cleanup.sql
DDL script that drops the schema, domains, and table structure on the target system. The utility uses the script if you import data in drop and create mode.
You can find the TAR archive file in the following location:
<temporary file directory>/idvmeta_backup_transfer_<timestamp>.tar

0 COMMENTS

We’d like to hear from you!