Re: MS Access to Oracle

Chris Wasser <chrisw> wrote:

>We are currently migrating from a PC based system to a workstation based
>system. We currently have ~900 tables to move from MS Access to Oracle. Any
>suggestions as to the quickest and easiest way to make this happen?
 

>Any help or advice would be greatly appreciated.
 

>-Chris
>chrisw_at_oxytropis.CNR.colostate.edu

   I recently migrated a pc based access system to Oracle using Powersoft's SDesigner. It's pricey but they have a trimmed down version called StarDesigner (have not used personally).

         Both of these tools will reverse engineer your access database(s) and generate a physical model which you can fine tune or adjust for Oracle or other back ends. They will then generate the necessary DDL to create your tables, indexes, triggers in Oracle. They will also generate alter statements in the event you physical model changes.

        For the number of tables you mentioned I would strongly suggest using a Case modeling tool.

Norm  

Best regards.
By, -MAX- Received on Thu Apr 04 1996 - 00:00:00 CEST