Anybody familiar with dbvista and oracle.....

Anybody familiar with dbvista and oracle.....

Post by lunati » Sat, 11 Apr 1998 04:00:00



Anybody familiar with dbvista and oracle.....
I ve' got an assignment. I need to transfer data files from dbvista running
on OS/2 warp to a sun machine runnig oracle.
Is there a common platform?
plus the main problem is that the primary key on the dbvista is different
from the one on oracle.
is there any way I can jut dump the data form OS/2 machine in to oracle on
sun and than manipulate the keys....
currently what we came up with is hooking up a iomega JAZ drive to a OS/2
machine (since lan is not possible on it , very old), exporting the data on
 it and
than hooking the JAZ drive to an NT machine which is hooked up to the sun
station on the network. But the process is awefull, too much hastle
Need help on it bad.
Thanx

 
 
 

Anybody familiar with dbvista and oracle.....

Post by Steve Grave » Wed, 15 Apr 1998 04:00:00


Do you have the original development kit for db_VISTA?  If so, use the tool
'dbexp' to export the data into comma delimited ascii files.  I'm sure Oracle
has a facility to import this standard file format.

If you don't have the development kit, you'll need to buy a copy of Raima
Database Manager (the product's new name).  The 'dbexp' in the current version
should work with the older db_VISTA database; the format hasn't changed in
quite some time.


> Anybody familiar with dbvista and oracle.....
> I ve' got an assignment. I need to transfer data files from dbvista running
> on OS/2 warp to a sun machine runnig oracle.
> Is there a common platform?
> plus the main problem is that the primary key on the dbvista is different
> from the one on oracle.
> is there any way I can jut dump the data form OS/2 machine in to oracle on
> sun and than manipulate the keys....
> currently what we came up with is hooking up a iomega JAZ drive to a OS/2
> machine (since lan is not possible on it , very old), exporting the data on
>  it and
> than hooking the JAZ drive to an NT machine which is hooked up to the sun
> station on the network. But the process is awefull, too much hastle
> Need help on it bad.
> Thanx


 
 
 

1. Anybody familiar with dbvista and oracle.....

YES!!!!
 - Martyn
   Surrey, England.

 - Martyn Cavett
   Senior ORACLE Analyst
   LGT Asset Management
   London, UK.


These views are my own and not those of my employer.  Normal conditions
apply.
nb. anonymous return address used - please replace reply address with those
given above.

2. 2d SP

3. constraint checks

4. Oracle Gateway to MSSQL

5. Raima Data Manager (dbVista) - ANYBODY USING?

6. adOpenKeyset

7. anybody familiar with Informix DataBlade?

8. Anybody familiar with PXPutAlpha() ??

9. Anybody still familiar with Filemaker Pro 2.1?

10. What is dbVista

11. dbVista