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

ssadbcopy for Data Export

Generates export files for a partial Data Vault copy. Run the ssadbcopy command on the source Data Vault system.

The ssadbcopy command uses the following syntax:

ssadbcopy
-d <database_name>
[-s <schema_name>]
[-t <table_name>]
-n <target_sct_file_directory>
[-r <source_temporary_file_directory>]
-u <Data_Vault_administrator_user>[/password]
[-f (enables automatic FTP file transfer)]
[-h (displays help screen)]
[-l <temporary directory for data files on the target external storage system>]
[-o (preserves the original data files locations)]
-b (admin task timeout in milliseconds)

The following table describes the ssadbcopy command arguments:

Option	Argument	Description
-d	database_name	Required. Database name from which you want to copy data. The database name is the same as the archive folder name in the Data Archive Data Vault target connection. You can copy data from one database at a time.
-s	schema_name	Required. Schema from which you want to copy data. You can copy data from one schema at a time. Use the full schema name. If you enter multiple schemas or use wildcards, the command fails. If you do not specify a schema, the utility copies data from all schemas in the database that you specify in the -d option.
-t	table_name	Optional. Table from which you want to copy data. You can copy data from one table at a time. If you enter multiple tables or use wildcards, the command fails. If you do not specify a table, the utility copies data from all tables from the schema that you specify in the -s option.
-n	target_data_file_directory	Required. Full path of the location in the target Data Vault system that stores the data files.
-r	source_temporary_file_directory	Location of the temporary directory on the source Data Vault system. The utility creates the ssadbcopy_temp folder in the specified directory and then creates the runtime files, log file, and export files inside of it. If you run two parallel ssadbcopy export jobs, do not use the same directory for -r. Default is the current working directory.
-l	-	Required when the -n directory is an external storage directory. Not required for a local file system. Full path of the location in the target external storage system that stores the data files that you want to import to the external storage system. Provide the -l option when you have manually transferred the data files to the target. When you run the utility, the data files are transferred to the -n directory.
-o	-	Optional. Keeps the original data file location. Use when data migration occurs between multiple Data Vault instances using a shared data file location within the same server.
-u	Data Vault_administrator_user>[/password]	Required. Name and password of the Data Vault administrator user account.
-f	-	Optional. Enables automatic FTP file transfer. If you specify the -f option, the utility uses the FTP server to transfer the export files to the target system. If you do not specify the -f option, you must manually transfer the export files to the target system. Default is manual transfer.
-h	-	Optional. Displays onscreen help. The help shows the syntax of the command and the possible flags.
-b		Task timeout, in milliseconds. This parameter is used for registration of SCT files during data import to the target. Default is 600000 ms.

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

ssadbcopy for Data Export

ssadbcopy for Data Export