Re: Foriegn DB Access Tool Needed
From: Steffen Goeldner <sgoeldner_at_eurodata.de>
Date: 1997/11/21
Message-ID: <34756F53.6E89_at_eurodata.de>#1/1
Date: 1997/11/21
Message-ID: <34756F53.6E89_at_eurodata.de>#1/1
The Oracle Open Client Adapter (OCA) - shipped with Developer 2000 -
let you access any ODBC Data Source.
There exists a Test-Tool (UBT) with a subset of the SQL*Plus
functionality. With UBT, you can copy data from ODBC to Oracle
(and back), e.g.:
copy -
from admin_at_odbc:MS_Access_2 -
to user/password_at_Ora7 -
replace MSysObjects -
using select -
Id -
, Type -
, DateCreate -
, DateUpdate -
, Name -
from MSysObjects
I don't know, why OCA is bundled with Developer 2000.
It should be Oracle's interest to facilitate an upsizing
tool like UBT.
Another product - Oracle Migration Wizard 1.x für MS Access -
is a frightful tool today.
Steffen Received on Fri Nov 21 1997 - 00:00:00 CET