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:

pfdbadmin user uid—Name of the InForm database administrator.
pfdbadmin user password—Password for the InForm database administrator.
Oracle sys uid—Oracle user account with SYSDBA privileges.
Oracle sys password—Password for the Oracle user account with SYSDBA privileges.
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 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:

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. Note: This name should not change.
trial_user_pass=Password for the owner of the study database schema.
orasys_user=Oracle database account with SYSDBA privileges.
orasys_user_pass=Password for the Oracle account with SYSDBA privileges.
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.
InFormRegistryBackup.txt—The contents of the InForm registry entry.

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