ImportMigrationFiles

Purpose

Imports an InForm study database dump file that was created by the ExportMigrationFiles command into a new database instance, and creates and configures the InForm study based on command parameters supplied when the command runs.

Location

<InstallationDirectory>\InForm\Bin\DBOra

Usage

ImportMigrationFiles.cmd <TNS_Service_Name>

Command line prompts

You are prompted for the following parameters:

• InForm study name—Enter the name of the InForm study you will create to import the dmp file.
• InForm server name—Enter the name of the InForm server to run the study.
• Trial user ID—Owner of the study database schema.
• Trial user password—Password for the owner of the study database schema in the InForm 6.3.1 environment.

  The password must comply with the requirements of the complexity verification function configured for the database.

• Study locale ISO name—For InForm 4.6 studies, enter en-US; for other InForm versions, enter an available study locale.
• Oracle sys uid—Oracle user account with SYSDBA privileges.
• Oracle sys password—Password for the Oracle user account with SYSDBA privileges.
• InForm database administrator name—The name for the InForm database administrator.
• InForm database administrator password—The password for the InForm database administrator.
• Dump file directory path—Location of the directory that you created on the InForm database server.
• Dump file name—Name of the DMP file to export.
• Was dump file created with Oracle 9 or 10?—Enter Y or N.
• Upgrade from InForm version?—Enter the version of the study you are migrating. Options are 4.6, 5.0, 5.5, 6.0, 6.1, or 6.2.
• Study type—Enter a trial type for your study. Options are LIVE, UAT, TRN, DEV, or QA.
• Study approval—Enter TRUE if you require approval for any deployment package, FALSE if your study does not require deployment package approval.

  Note: By default, Live and UAT studies require study approval.

• Deployment backup folder—Enter a path on the InForm database server that will be used for database recovery during study deployment. For example /u01/app/deploybackup.

  Note: The physical must exist before you run the ImportMigrationFiles command.

• Deployment service port—Enter a port number for the Central Designer application to communicate with the InForm application server to transmit deployment packages.
• Authentication service port—Enter a port number for the InForm application server to authenticate users for the Reporting and Analysis module.
• ODMSubmit service port—Enter a port number for the Clinical Data API to exchange SOAP requests.

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:

• InForm_trial_name=InForm studyname.
• InForm_server_name=InForm server name.
• trial_user=Owner of the study database schema.
• trial_user_pass=Password for the owner of the study database schema.
• study_locale_ISO_name=Study locale.
  • For InForm 4.6 studies, enter en-US.
  • For InForm 5.0, 5.5, 6.0, 6.1, and 6.2 studies, enter one of the available study locales.
• orasys_user=Oracle user account with SYSDBA privileges.
• orasys_user_pass=Password for the Oracle user account with SYSDBA privileges.
• pfdbauid=InForm Database Administrator Username (pfdbadmin).
• pfdbapid=InForm database administrator password.
• dump_file_dir_path=Database dump file directory.
• dump_file_name=Database dump file name.
• dump_created_with_exp=(Y or N) Was the dump file created with exp.exe (Oracle 9 or 10) or with expdp.exe (Oracle 11)?
• UpgradeFromInFormVersion=4.6, 5.0, 5.5, 6.0, 6.1, or 6.2.
• trial_type=UAT, LIVE, TRN, DEV, or QA.
• trial_approval=TRUE or FALSE.
• deployment_backup_folder=The path on the InForm database server that will be used for database recovery during study deployment.
• deployment_service_port=The port number for the Central Designer application to communicate with the InForm application server to transmit deployment packages.

  Recommended port is 14040, however any port other than 80 or 443 can be used.

• auth_service_port=The port number for the InForm application to authenticate users for the Reporting and Analysis module.

  Recommended port is 14041, however any port other than 80 or 443 can be used.

• odm_service_port=The port number for the Clinical Data API to exchange SOAP requests.

  Recommended port is 14042, however any port other than 80 or 443 can be used.

Notes

Based on the parameters submitted when the command runs, the ImportMigrationFiles command imports the InForm study database dump file, and performs study configuration tasks, including:

• Creates the InForm server and study.
• Upgrades the study schema.
• Updates study statistics.
• Sets the MedML Installer server.
• Upgrades resources.
• Terminate obsolete users.
• Sets the deployment web service port.

Example

ImportMigrationFiles.cmd TRIAL1

• Access to Oracle Support
• Accessibility
• Legal Notices

Copyright © 2019, 2020 Oracle and/or its affiliates. All rights reserved.