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 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—User name of the InForm database administrator..
- pfdbapid—Password for the InForm database administrator.
- 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.