Kbase P1734: How to Migrate a db to Oracle version 8 on Windows NT
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/22/2003 |
|
Status: Unverified
GOAL:
How to Migrate a db to Oracle version 8 on Windows NT
GOAL:
How to push a database through Progress dataserver to Oracle version 8 on Windows NT
FIX:
Steps:
1) Create Database with Oracle (called test in my example) through
Oracle->Database Administration->Database Configuration Assistant (typical, multipurpose...)on NT.
Takes a while to finish.
Once finished it is possible to check on the NT services that the oracle database just created is up and running as a service.
2) Oracle81->Application Development-> SQL plus and "log on" as user: system, password: manager (It is the DBA Oracle user by default).
Then you can create another user for security reasons jnunez with password jnunez and give him dba permissions with following commands:
create user jnunez identified by jnunez;
grant dba to jnunez;
commit;
exit;
3) Progress Data Administration-> connect to the chosen DB (that we want to migrate, in my test is call also protest),
Dataserver menu->ORACLE Utilities->Schema Migration Tools->Progress DB to Oracle
A window appears in which it is necessary to fill in:
original progress db:protest
connect parameters for PROGRESS: <current working database>
Name of schema holder Database: holder1
Logical name for Oracle Database: test
what version of Oracle:8
Oracle owner's username: jnunez
Oracle user's password: jnunez
Oracle connect parameters: -dt ORACLE
*The rest as by default(including "connect parameters for PROGRESS:" that is "<current working database>")
Options "Progress 4GL Compatible Objects" and "Load SQL" ticked.
To move also the data and not only the schema the "Move Data" option has to be ticked.
In "Name of schema holder Database:" the name of the new schema holder that is going to be created connected to the pulled Oracle db has to be entered.
At the end of the process a new procedure file (.p) is created, called in my example ctest.p, that can be used to connect to the new created Progress schema holder.