ExportMigrationFiles

Purpose

Modifies the InForm study database for migration, creates a dump file of the modified database, backs up the InForm registry, and records the InForm server information in a text file that you can use to migrate an InForm study to a new environment.

Location

The InForm\InstallSupport folder on the product image.

Usage

ExportMigrationFiles.cmd <TNS_Service_Name>

Command line prompts

You are prompted for the following parameters:

Trial user ID —Owner of the study database schema.
Trial user password —Password for the owner of the study database schema.
Oracle system uid —Oracle database system user.
Oracle system user password —Password for the Oracle database system user.
Oracle sys uid —Oracle database sys user.
Oracle sys password —Password for the Oracle database sys user.
Dump file directory path —Directory on the InForm database server to store the dump file.
Dump file name —Name of the DMP file to export.
Note: Do not include spaces in the dump file name or the directory path to the dump file.

For legacy purposes, 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.

Parameter file contents

You can pass the following parameters in a parameter file:

trial_user=Owner of the study database schema. Note: This name should not change.
trial_user_pass=Password for the owner of the study database schema.
orasystem_user=Oracle database system user.
orasystem_user_pass=Password for the Oracle database system user.
orasys_user=Oracle database sys user.
orasys_user_pass=Password for the Oracle database sys user.
dump_file_dir_path=Directory on the InForm database server where the database dump file will be created.
dump_file_name=Database dump file name.

Notes

The ExportMigrationFiles command creates the following files:

<dump_file_name> .dmp —The dump file name specified on the command line. The dump file is located in the specified directory on the InForm database server.
pfadmin_view_service.txt —Text file containing the information for the servers and studies running on the InForm application server.
InForm.reg —A registry file that contains the contents of the exported from:
- HHKEY_LOCAL_MACHINE\SOFTWARE\PhaseForward (InForm 4.6, 5.0 , or 5.5 studies)
- HHKEY_LOCAL_MACHINE\SOFTWARE\OracleHS (InForm 6.0 studies)

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.

Example

ExportMigrationFiles.cmd trial1