exportdb

Purpose

Exports the given database schema.

Location

<Installation_Directory>\InForm\bin\DBOra folder.

Usage

exportdb [connection string] [dump-file-directory-path] [dump-file-name] /prompt [log options]

exportdb [connection string] [dump-file-directory-path] [dump-file-name] /accountparams:[paramfile] [log options]

exportdb [connection string] [dump-file-directory-path] [dump-file-name] [version] /prompt [log options]

exportdb [connection string] [dump-file-directory-path] [dump-file-name] [version] /accountparams:[paramfile] [log options]

Where:

Parameter	Description
connection-string	Database TNS Instance Name
dump-file-directory-path	Physical path on database server where the dump should be created. The path must conform to the proper OS path format, and that it should be expected that the path is case-sensitive.
dump-file-name	Filename to give the exported dump file. Note: The name must conform to the proper OS format for the database server, and that it should be expected that the name is case-sensitive.
version	Target database version. Only specify if the dump will be imported into a lower version database.
paramfile	Path to text file containing the list of parameters.
log options	Optional parameters for specifying the log file name and/or location. The log file defaults to being named ExportDB.log. The log file path defaults to the current working directory. Options: /LogFile:[filespec] filespec = fully qualified name and path for created log file. If a relative path is given, it is based from the current working folder. Overrides the logfile-path to be the resolved path to the given filespec. Do not specify this if either of the other logging options are specified. /LogFilePath:[pathspec] pathspec = fully qualified path to create the log file in. If a relative path is given, it is based from the current working folder. Overrides the logfile-path to be the resolved path to the given pathspec. Does not change logfile-name. /LogFileName:[filename] filespec = Filename for the log file. Overrides the logfile-name for the log file. Does not change logfile-path.

Command line prompts

If using prompting, you are prompted for the following parameters:

• Schema Owner User ID — Database trial/schema owner user ID.
• Database Administrator User Name — Name of the Database Administrator User (for example, pfdbadmin).
• Database Administrator User Password — Password for the Database Administrator User.

Parameter file contents

When using a parameter file, the path to a text file is given. The format of the parameter file is parameter=value, with each value on a separate line, and no spaces between the parameter name, =, and value.

The parameter file must contain the following parameters:

• Trial_user — Trial/Schema Owner User ID for the study to export.
• Admin_user — Name of the InForm Database Administrator (for example, pfadmin)
• Admin_user_pass — Password for the InForm Database Administrator User.

Example

exportdb trial1 /backups backup.dmp /prompt

exportdb trial1 /backups backup.dmp /accountparams:myparamfile.txt

exportdb trial1 /backups backup.dmp /prompt /logfilepath:c:\exportlogs