Progress
DataServer
for ORACLE Guide


Running the Progress-to-ORACLE Utility

You can run the Progress-to-ORACLE utility interactively or in batch mode. Follow these steps to migrate a Progress database to ORACLE:

  1. Create a target ORACLE7 or ORACLE8 database if you do not already have one. If you want to use tablespaces, you must define them in your ORACLE database before running the Progress-to-ORACLE utility. When developing a new DataServer application, start with a new empty database.
  2. Start an instance of your target ORACLE database.
  3. Make sure that the ORACLE_SID environment variable is set to the ORACLE database name.
  4. Make sure that the ORACLE_HOME environment variable is set to the directory where you installed ORACLE.
  5. Start the Progress client and connect to the Progress database that you want to migrate to ORACLE.
  6. NOTE: For a DBE DataServer application, you must specify the Internal Code Page (-cpinternal) and Stream Code Page (-cpstream) parameters when you start the Progress client. The values that you specify for these parameters much match the code page that the ORACLE database uses.

  7. On Windows, from the Data Admin tool choose DataServer ORACLE Utilities Schema Migration Tools PROGRESS DB to ORACLE.
  8. On UNIX, access the utility from the DataServer menu in the Data Dictionary. Or, you can start Progress and run the utility from the command line:

    pro source_db -p prodict/ora/protoora.p 
    

  9. The following screen appears and prompts you for the information described in Table 5–9:
  10. Table 5–9: Progress-to-ORACLE Utility
    Interface Element
    Description
    Original Progress Database
    Enter the source database name.
    Connect parameters for Progress
    Enter parameters for the connection to the source Progress database, which is the current working database. If you started the utility at the command line, do not enter any parameters that you specified when you started the utility
    Name of Schema holder Database
    Enter the name for the schema holder. The utility creates the schema holder if it does not exist.
    Logical name for ORACLE Database
    Enter the ORACLE database logical name. The logical database name is the name of the schema image and the name you will use to refer to the ORACLE database in applications. The database’s logical name must be different than the name you enter for the schema holder and different than the name of any other schema image existing in that schema holder.
    What version of ORACLE
    Enter the version of ORACLE you are using. Possible values are 7 or 8. The default is 7.
    ORACLE Owner’s Username
    Enter the ORACLE database owner’s name.
    ORACLE User’s password
    Enter the owner’s password.
    ORACLE connect parameters
    Enter additional connection parameters for the schema image. The utility provides the required -U and -P parameters, but you might want to specify others, such as any -Dsrv options.
    Code page for Schema Image
    Enter the Progress name for the code page that the ORACLE Call Interface (OCI) uses. By default, the code page for a schema image is ibm850. You can leave this field blank and use the Change Code Page utility to add the code page information for the schema image later.
    Tables
    Enter the name of the ORACLE tablespace where you want to store schema information. The default is the ORACLE user’s default tablespace.
    Indexes
    Enter the name of the ORACLE tablespace where you want to store index information. The default is the ORACLE user’s default tablespace.
    Progress 4GL Compatible Objects
    Check this toggle box to create an ORACLE database that supports arrays, case-insensitive indexes, backward and forward scrolling, and the Progress record identifier. These objects result in additional columns added to ORACLE tables. This is the default option. If you do not want Progress 4GL compatibility, deselect the toggle box.
    Load SQL
    Check this toggle box to load the .sql file that contains the data definitions for your Progress database into the ORACLE database. This is the default option.
    Move Data
    Check this toggle box to dump and load data from your Progress database to the ORACLE database. Copying data from a large database can take a long time. For example, you might not check this box if you want to dump and load data at a more convenient time.

If you want a complete migration of your Progress database to ORACLE, you must enter information in all fields and check all toggle boxes.

The utility creates a schema holder, an ORACLE database that contains the objects from your Progress database, and a startup procedure that you can use to connect to your schema holder. The startup procedure derives its name from the logical name for your ORACLE database. For example, if you specified “orasports” as the logical database name, the utility creates the corasports.p startup procedure.

Follow these steps to run the Progress-to-ORACLE utility in batch mode on a UNIX client machine:

  1. Create a target ORACLE database. You must use an empty ORACLE database when you run the Progress-to-ORACLE utility.
  2. Start an instance of your target ORACLE database.
  3. Make sure that the ORACLE_SID environment variable is set to the ORACLE database name.
  4. Make sure that the ORACLE_HOME environment variable is set to the directory where you installed ORACLE.
  5. On your client machine, pass parameters to the utility by setting the environment variables listed in Table 5–10.
  6. Table 5–10: Progress-to-ORACLE Utility Batch Parameters
    Environment Variable
    Description
    PRODBNAME
    Specify the source Progress database name.
    PROCONPARMS
    Specify parameters for the connection to the source Progress database.
    SHDBNAME
    Specify the new schema-holder name.
    ORADBNAME
    Specify the ORACLE database logical name. The database’s logical name can be the same as its physical name, but it must be different from the name you enter for the schema holder.
    ORAVERSION
    Specify the version of ORACLE you are using. Possible values are 7 or 8. The default is 7.
    ORAUSERNAME
    Specify the ORACLE user’s name.
    ORAPASSWORD
    Specify the user’s password.
    ORACONPARMS
    Specify additional connection parameters for the schema holder.
    ORACODEPAGE
    Specify the Progress name for the code page that the ORACLE Call Interface (OCI) uses. By default, the code page for a schema image is ibm850. You can leave this field blank and use the Change Code Page utility to add the code page information for the schema image later.
    TABLEAREA
    Enter the name of the ORACLE tablespace where you want to store schema information. The default is the SYSTEM tablespace.
    INDEXAREA
    Enter the name of the ORACLE tablespace where you want to store index information. The default is the SYSTEM tablespace.
    COMPATIBLE
    Specify YES to create an ORACLE database that supports arrays, case-insensitive indexes, backward and forward scrolling, and the Progress record identifier. These objects result in additional columns added to ORACLE tables. Enter NO if you do not want the Extended 4GL capability. The default is YES.
    LOADSQL
    Specify YES to load the .sql file that contains the data definitions for your Progress database into the ORACLE database. Specify NO if you do not want the utility to load the .sql file, for example if you want to edit the file before loading it. The default is YES.
    MOVEDATA
    Specify YES to dump and load data. Otherwise, if you do not want to populate the ORACLE database, specify NO. For example, you might specify NO if your database is large, and you want to dump and load data at a more convenient time. The default is NO.

  7. Enter these commands to set and export environment variables at the system prompt before running protoora.p:
  8. PRODBNAME=db-name; export PRODBNAME
    PROCONPARMS="-1 -i"
    SHDBNAME=schema-holder-name; export SHDBNAME
    .
    .
    .
    pro -b -p prodict/ora/protoora.r 
    


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095