Migrating the randomization source to a new database

Previous Topic

Next Topic

Book Contents
Migrating the randomization source to a new database
  1. To migrate trial randomization to a new randomization source database, use the following syntax:

    RandomizationMigration.exe <trialname> /NewRNDSchema <dbserver> /prompt <outfile>

    where:

    • trialname—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.

    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 system user.
    • OracleSysPID—The password for the Oracle system user.
    • 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.
  2. Restart the trial after the migration is complete.

Copyright © 2014, 2017 Oracle and/or its affiliates. All rights reserved.