Import the InForm Portal DMP file

To import the InForm Portal DMP file, run ImportPortalMigrationFiles.cmd (located in the <InstallationDirectory>\InForm\Bin\DBOra folder on the InForm application server), using the following syntax:

ImportPortalMigrationFiles.cmd <TNS_Service_Name> <Portal_TNS_Service_Name>

where:

TNS_Service_Name—TNS name for the database instance.
Portal_TNS_Service_Name—TNS name for the Portal database instance.

You are prompted for the following values:

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 user password—Password for the Oracle database sys user.
Oracle data folder path—The path to the Oracle database data folder. For example:
/u01/app/oracle/oradata
Trial UID—Owner of the study database schema.
Trial user password—Password for the owner of the study database schema.
portal_user—Owner of the InForm Portal database schema.
portal_user_pass—Password for the owner of the InForm Portal database schema.
inform_trial_name—Name of the <if> study where the portal application from the DMP file is imported.
pfdbauid—InForm service database admin user.
pfdbapid—Password for the InForm service database admin user.
Dump file directory path—Location of the directory where you created the dump file:
- For an Oracle 9i or 10g, the InForm application server.
- For an Oracle 11g database, the InForm database server.
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.
Dump file name—Name of the DMP file to export.
Was dump file created with exp?—Enter N if the dump file was created from Oracle database 11 or later. Otherwise, enter Y.

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.

The ImportPortalMigrationFiles.cmd command imports the portal DMP file and upgrades it. It also migrates the information from the InForm Portal database to the InForm study database.