RE: RDB to Oracle and Rdb with Forms

Hi Tim,

Yes, it is possible to run Oracle forms against Rdb - can either connect via ODBC or install SQLNet into your Rdb database. The Rdb mailing list would be a good place to get help on this (see http://www.jcc.com/jccs_oracle_list_servers.htm) JCC (who host the Rdb mailing list) offer a course on using Developer with Rdb - see http://www.jcc.com/training.htm

I was only involved on the DBA side so can't comment in-depth on the development issues. Some things to keep in mind are Rdb's handling of read only vs read-write transactions and whether you want your form to connect direct to your Rdb database or for example build an intermediate Oracle link database (containing dblinks to the Rdb tables) and then the forms connect to the link database - might be handy if your forms need to connect to multiple Rdb databases (as ours did).

Converting Rdb to Oracle

Some ideas:
rmu/unload to text file and load in via SQL Loader select out via SQL to csv file and load in via SQL Loader Load SQL Net into Rdb and use create as select commands or insert commands May want to reverse engineer your Rdb into say Designer and have Designer create out the necessary Oracle commands You could also get the DDL commands by spooling from the Rdb system tables or by manipulating the output of an rmu/extract command (rmu/extract would be REALLY nice for Oracle - create the entire DDL to rebuild the database with 1 built-in command)

This has been discussed on the Rdb list a number of times and you will find information in their archives.

Hope all this helps.

Regards,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au

-----Original Message-----
From: Sawmiller J Timothy [mailto:tsawmiller_at_lycos.com] Sent: Thursday, 18 January 2001 5:26
To: Multiple recipients of list ORACLE-L Subject: RDB to Oracle

Does anyone have experiences to share regarding porting an RDB database to an Oracle database? Standard processes? Tips? Warnings? Also, can an Oracle form run against an RDB database? Received on Wed Jan 17 2001 - 21:27:19 CST