Re: Moving tables from Access to Oracle

From: Mario van Essen <marvaes_at_hacom.nl>
Date: 1996/04/18
Message-ID: <4l5vsp$kl2_at_big.hacom.nl>#1/1


On Tue, 16 Apr 1996 20:19:51 +0100, Steve Kay <steve_at_starbug1.demon.co.uk> wrote:

>
>
>Anybody have any advice on the process of moving Access tables over
>to Oracle tables?
>
>We've got a load of tables which need moving over, but Microsoft tell
>us that once a table has been created in Access, its SQL definition
>is lost and therefore has to be recreated manually in Oracle.
>
>Any ideas or solutions for this bummer of a job?
>
>Thanks,
>
>Steve Kay.
>d- s+ a- US++ p-- w x++ b++ DI++++ G e* h--

Steve,

We solved teh same problem like this:

we did the 're-engineering' from MS-Access with S-Designor (4.2.2) from Powersoft (costs you almost nothing compared to Oracle). The technical datamodel was converted with S-Designor to an Oracle based technical datamodel (just 4 clicks with the mouse, you can also recreate  an conceptual datamodel) and implemented into Oracle 7.2.

This all from my PC, using ODBC. Confiruration: Win NT 4.0/Oracle 7.2 Win '95/Personal Oracle for Win '95/32-bit ODBC/32-bit SQL*NET

Mario


drs. ing. Mario van Essen                                N.V. REMU
   marvaes_at_hacom.nl               @..@                Informatiezaken
    +31-35-6235451               (----)               +31-30-2975515
      Hilversum                 (>____<)                  Utrecht
---------------------------------------------------------------------
------------"The Netherlands, best place to be on earth"-------------
---------------------------------------------------------------------
- "Life at the Net is like living in space and looking down, asking--
-  yourself what will be going on down there on earth"---------------
---------------------------------------------------------------------
- Everything i write is my own opinion, not that of the N.V. REMU----
Received on Thu Apr 18 1996 - 00:00:00 CEST

Original text of this message