Previous Topic

Next Topic

Book Contents
Migrating the randomization source to a new database
  1. Migrate the Microsoft Access randomization source database to the InForm application server.
  2. 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>.

  3. 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.
  4. Activate the randomization rule in the InForm application.
  5. Restart the trial after the migration is complete.
Send Feedback