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:
- 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.
- Start an instance of your target ORACLE database.
- Make sure that the ORACLE_SID environment variable is set to the ORACLE database name.
- Make sure that the ORACLE_HOME environment variable is set to the directory where you installed ORACLE.
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.- Start the Progress client and connect to the Progress database that you want to migrate to ORACLE.
- On Windows, from the Data Admin tool choose DataServer
ORACLE Utilities
Schema Migration Tools
PROGRESS DB to ORACLE.
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:
- The following screen appears and prompts you for the information described in Table 5–9:
![]()
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:
- Create a target ORACLE database. You must use an empty ORACLE database when you run the Progress-to-ORACLE utility.
- Start an instance of your target ORACLE database.
- Make sure that the ORACLE_SID environment variable is set to the ORACLE database name.
- Make sure that the ORACLE_HOME environment variable is set to the directory where you installed ORACLE.
- On your client machine, pass parameters to the utility by setting the environment variables listed in Table 5–10.
- Enter these commands to set and export environment variables at the system prompt before running
protoora.p
:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |