Export the InForm study database
To export the InForm study database:
- Copy the <Local Drive:>\OracleHS\InstallSupport folder from the downloaded product image to the InForm application server.
- Run ExportMigrationFiles.cmd (located in the <Local Drive:>\OracleHS\InstallSupport folder on the InForm application server) to back up each InForm study database as a DMP file, using the following syntax:
ExportMigrationFiles.cmd <TNS_Service_Name> [/accountparams:accountparams.txt] [/prompt] [/logfilepath:<logfilepath>]
where:
- TNS_Service_Name—TNS name for the database instance.
- logfilepath—Optional path where you can specify the log files to go.
You are prompted for the following values:
- pfdbadmin user—Name of the InForm database administrator.
- pfdbadmin password—Password for the InForm database administrator.
- Trial user ID—Owner of the study database schema.
- Trial user password—Password for the owner of the study database schema.
- Dump file directory path—Directory path on the InForm Database server where the export dump files are created.
Note: When you specify the directory path, be sure to use the directory path delimiters ( / or \ ) that are appropriate for the database server operating system.
If a parameter file is used, there are some additional options that can be specified in the file.
You can also pass the parameters by using the /accountparams:"path_to_parameter_file" command option.
When specified, this option includes the path to a text file that contains the values required to run the command. The format of the parameter file is parameter=value. There is a new line for each parameter, and there are no spaces on a line. For more information, see Command and script reference in the Installation Guide.
Parameter file contents
You can pass the following parameters in a parameter file:
- pfdbadmin_user—Name of the InForm database administrator.
- pfdbadmin_user_pass—Password for the InForm database administrator.
- trial_user—Owner of the study database schema.
- trial_user_pass—Password for the owner of the study database schema.
- dump_file_dir_path—Location of the directory where you created the dump file.
- schemas—The list of all integration schemas for the trial that needs to be exported. This is an optional parameter.
Note: The value to this parameter should be passed as a comma separated value.
Note: If error messages indicating that the system cannot find the paths specified for the System Product Locale and the System Study Locale appear, disregard the messages and continue with the migration.
Note: Customer-defined databases or randomization databases that are not part of the study database must be exported using standard database commands. For more information, see the Oracle Database documentation.