| Title: | DEC Rdb against the World |
| Moderator: | HERON::GODFRIND |
| Created: | Fri Jun 12 1987 |
| Last Modified: | Thu Feb 23 1995 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1348 |
| Total number of notes: | 5438 |
Anyone know if there's a way to convert Oracle data to a RMS format?
My customer has Oracle, but wants to move into an Rdb environment;
however, he's looking for a way to not having to re-enter all the
information. If Oracle data can be converted to RMS format, then Rdb
can pull into it's database.
Thanks,
Karen Wood
DTN 553-3247
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 491.1 | Try Trifox (408)7491331 | SNO78C::BELAKHOV | The ORACLEBUSTER !!! | Wed Nov 15 1989 22:58 | 8 |
Trifox tools can provide the functionality of moving ORACLE data
directly to Rdb/VMS (including the metadata). They also have
application conversion tools.
There are notes in this conference that mention these tools.
Regards,
Michael
| |||||
| 491.2 | A few other thoughts | MAIL::DUNCANG | Gerry Duncan @KCO | Thu Nov 16 1989 00:01 | 29 |
Several options:
>> You can use SQL*plus (Oracle interactive SQL) to list the tables to a
text file. Depending on the datatypes, you may then be able to define
an RMS definition in CDD and use Datatrieve or the Rdb V3.1 LOAD
utility. It would go something like this:
SELECT * FROM your_table;
I've used this method before and it got me by for a demo. I had
some trouble with datatypes so this may not be the best long term
solution.
>> Worst case would be to write a simple program to read the test file and
parse out special characters (dollar signs or date hyphens) prior to
loading into Rdb.
>> Trifox will work as mentioned in .1. Also, Smartstar now has the
ability to copy Oracle table definitions AND data DIRECTLY from
Oracle to Rdb. This may be the best of all.
>> You could also write a program to read the oracle database (as opposed
to using SQL*plus) and create a RMS file which would/should load
more cleanly into Rdb. Also, there is probably no reason why you
couldn't read the Oracle database and write to the Rdb database
in the same program which would eliminate the RMS file completely.
-- gerry
| |||||