Progress
DataServer
for ORACLE Guide


ORACLE Demonstration Database

The demonstration database allows you to run the sample procedures from this chapter, or your own procedures, against an ORACLE7 or ORACLE8 database. This demonstration database is not part of the Progress installation media. To create and initialize the ORACLE database, you use the Progress-to-ORACLE utility to migrate the Progress Sports database to the version of ORACLE you are using. Connect to the schema holder that the utility creates, then run the tutorial exercises or your own Progress applications against the ORACLE Sports database.

Follow these steps to migrate the Progress Sports database to ORACLE:

  1. Make sure the ORACLE background processes are running for your ORACLE database.
  2. Start the DataServer processes that your configuration requires:
    • Local configuration — Start the Progress client.
    • Remote configuration — Start the DataServer broker on the host machine, and the Progress client on the client machine.
    • See "Connecting the DataServer," for the startup commands.

  3. Connect to the Progress database that is to be migrated to ORACLE.
  4. On Windows, from the Data Admin tool choose DataServer ORACLE Utilities Schema Migration Tools PROGRESS DB to ORACLE.
  5. If you are using character-based Progress, access the Data Dictionary to access the DataServer utilities.

    NOTE: The examples demonstrate the ORACLE utilities for Windows. If you are using Progress on UNIX, you will see slightly different interfaces that have the same components as these examples.

  6. Provide the information noted in Table 5–1.
  7. Table 5–1: Progress-to-ORACLE Utility
    Interface Element
    Description
    Original Progress Database
    Accept the default value.
    Connect parameters for Progress Db
    Accept the default value.
    Name of Schema holder Database
    Enter myholder.
    Logical name for ORACLE Database
    Enter mysports.
    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
    Leave this field blank.
    Code page for Schema Image
    Accept the default code page.
    Tables
    Leave this field blank. The Sports database would not benefit from ORACLE tablespaces.
    Indexes
    Leave this field blank. The Sports database would not benefit from storing indexes in separate ORACLE tablespaces.
    Progress 4GL Compatible Objects
    Check this toggle box to create an ORACLE database that supports arrays, case-insensitive indexes, Find PREV/LAST, and the Progress record identifier.
    Load SQL
    Check this toggle box. In order to create the schema in ORACLE you must select the Load SQL option. If you leave the Load SQL option unselected only the SQL file is created.
    Move Data
    Check this toggle box so that the migrated Sports database contains data.

  8. Choose OK. The utility creates the myholder database, adds ORACLE schema information to it, and connects you to the ORACLE database.
  9. Choose DataServer ORACLE Utilities for a menu that allows you to access the DataServer utilities described in Table 5–2.
  10. Table 5–2: DataServer for ORACLE Utilities Menu 
    ORACLE Utilities

    Create DataServer Schema...

    Use this utility to create a schema image for an ORACLE database.

    Update/Add Table Definitions...

    Use this utility to update the schema image to reflect any changes you made to the ORACLE data definitions.

    Verify Table Definition...

    Use this utility to make sure that the data definitions in the schema image match your ORACLE data definitions.

    Edit Connection Information...

    Use this utility to change connection information or the logical database name in a schema image.

    Change DataServer Schema Code Page...

    Change the code page in a schema image.

    Delete DataServer Schema...

    Use this utility to delete a schema image.

    Run ORACLE SQL *Plus...

    Use this utility to modify your ORACLE database with SQL*PLUS commands.

    Schema Migration Tools

    Access utilities for migrating a Progress database to an ORACLE database and for incrementally migrating a schema to ORACLE and adjusting schema image.

  11. When you access an ORACLE utility, you might see a dialog box for verifying your user ID and password. Choose OK, or enter a new user ID and password with the privileges required for creating and updating a schema image. See the "Schema-holder Security" section in "Configuring the DataServer," for information.
NOTE: The DataServer makes an additional connection to the schema holder when it creates, updates, or verifies a schema image. If you are connecting to multiple databases or schema images, make sure that you set the Number of Databases (-h) parameter to a value that accommodates the number of databases and schema images plus one.


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