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:
- Make sure the ORACLE background processes are running for your ORACLE database.
- 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.
- Connect to the Progress database that is to be migrated to ORACLE.
- On Windows, from the Data Admin tool choose DataServer
ORACLE Utilities
Schema Migration Tools
PROGRESS DB to ORACLE.
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.- Provide the information noted in Table 5–1.
- Choose OK. The utility creates the myholder database, adds ORACLE schema information to it, and connects you to the ORACLE database.
- Choose DataServer
ORACLE Utilities for a menu that allows you to access the DataServer utilities described in Table 5–2.
- 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 |