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


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

Original text of this message