Migrating the randomization source to a new database
- Migrate the Microsoft Access randomization source database to the InForm application server.
- Run the following command:
pfadmin config trial <StudyName> /Rnd <TNS_Service_Name> [/accountparams:"path_to_parameter_file" | /prompt]
This command creates the <StudyName>RND randomization ODBC data source for the database identified with <TNS_Service_Name>.
- To migrate trial randomization to a new randomization source database, use the following syntax:
RandomizationMigration.exe <StudyName> /NewRNDSchema <dbserver> /prompt <outfile> <RndMdbPathAndFilename>
where:
- StudyName—The name of the trial for which you are migrating randomization to an Oracle database.
- outfile—The name of the log file used to record the results of the RandomizationMigration command.
- dbserver—The TNS name for the Oracle server to store the new randomization schema.
- RndMdbPathAndFilename—The complete path and file name of the Microsoft Access randomization source database.
The name of the data file and tablespace for the randomization use the InFormRND_<trialname> format. For example, InFormRND_pfst461.dbf for the data file name, and InFormRND_pfst461 for the tablespace name.
When prompted, enter the following parameters:
- OracleSysUID—The name of the Oracle user account with SYSDBA privileges.
- OracleSysPID—The password for the Oracle user account with SYSDBA privileges.
- NewRNDSchemaUID—The name of the owner of the new randomization schema.
- NewRNDSchemaPID—The password for the owner of the new randomization schema.
The results of the command are recorded in the output file you specify with the command.
- If the migration is successful, the output file will include the word SUCCESS.
- If the migration fails, the first line of the output file will be ERROR, followed by one or more error messages that indicate the cause of the failure.
- Activate the randomization rule in the InForm application.
- Restart the trial after the migration is complete.