Re: Migrating from Access to Oracle

look in the oracle technical network. latest version and all documents. i think i heard something about an access2000 version out now or by the end of the month - dont quote on this though.

---
Tony Johnson

"James F. Hurff" wrote:

> I have a couple of questions on this topic. I would greatly appreciate any
> assistance:
>
> 1. Is the Access conversion utility still available to download from
> Oracle...I cannot seem to find it on the Free/Trial Software download page
> where it used to be?
> 2. Is the utility compatible with Access 2000 or do I need to export the
> Access database to a Access 97 format?
> 3. If the cascade update/delete is enabled in the Access design, are
> associated triggers created on the Oracle side?
> 4. If the Autonumber datatype is used in the Access design, are associated
> sequences created on the Oracle side?
> 5. Are the entity relationships passed from Access to Oracle?
>
> Thanks in advance.
>
> Michael Ho <infoage_at_hk.super.net> wrote in message
> news:37877313.F298D59_at_hk.super.net...
> > Well my suggestion is if you can affort Oracle 8, which about US$300-500
> per
> > concurrent user, try change it to Oracle. The beneficiary is huge. More
> > secure data, fast performance, highly reliable, extremely scalable.
> >
> > I have use Access 2.0 for long time, very problematic when the system goes
> > complex and large. Upgrade to 95, solve some problem, raise some another.
> > Upgrade again to 97, still the same. I never user the Access to Oracle
> > Migration Kit. (My problem, I never trust those user friendly interface)
> > What I did is:
> >
> > 1. create exactly the database on Oracle exactly same in access.
> > 2. Transfer data to Oracle.
> > 3. Attach the Oracle Database into Access using ODBC.
> > 4. If you use cascade update relation in access, you may need program some
> > trigger in oracle.
> >
> > Just that, the migration is complete, work for Access 2.0 or 95 or 97 .
> > Then you can further improve the performance by :
> >
> > 1. Modify the Query into pass-through query or database view.
> > 2. Rewrite complex operation into database procedure.
> >
> > Personally I think for that price, Oracle is very competitive towards SQL
> > Server. But the benefit is huge, Oracle is the market leader afterall.
> Try
> > to compare a Ferrari with a Honda.
> >
> > Hope it helps.
> > Michael
> >
> > CMG wrote:
> >
> > > Greetings -
> > >
> > > Our business is built on Access 2, but time to move to SQL Server, or
> > > preferrably, Oracle, retaining Access as the front end. We'll upsize to
> > > Acc97, then migrate to Oracle, if it really works.
> > >
> > > Has anyone tried such a migration? What was your experience? Any input
> > > or
> > > links you can provide would be greatly appreciated. I do have the Oracle
> > > Migration Tools, but I much rather hear the truth about migration from
> > > an unbiased source.
> > >
> > > Thanks,
> > > Adam Kahn
> >
Received on Wed Aug 11 1999 - 00:20:33 CDT