|
|
|
|
Back up the InForm study database—Oracle 10g
If you are migrating an InForm 4.6 or InForm 5.0 study from an Oracle 10g database, backing up the InForm study database is required. You will import the DMP file you create in this step during the migration to the InForm 6.1.1.4 release. For more information, see Import the InForm study DMP file.
To back up an InForm 4.6 or InForm 5.0 study database to a DMP file:
- Copy the InForm\InstallSupport folder from the downloaded ISO image to the InForm application server.
- Run ExportDBUpgrade.cmd (located in the InForm\InstallSupport folder) on the InForm application server to back up each InForm study database as a DMP file, using the following syntax:
ExportDBUpgrade.cmd <DMP_file> <TNS_Service_Name>
where:
- DMP_file—Name of the DMP file, using the full path.
Note: Do not include spaces in the DMP file name.
- TNS_Service_Name—TNS name for the database instance.
You are prompted for the following values:
- trial_user=Owner of the InForm study database schema.
- trial_user_password=Password for the owner of the InForm study database schema.
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.
Example:
ExportDBUpgrade.cmd D:\PFST46.dmp TRIAL1 /accountparams:"e:\scripts\exparams.txt"
The ExportDBUpgrade command creates a log file <DMP_file>.log in the current directory.
- DMP_file—Name of the DMP file, using the full path.
