Re: Transfering Access 2000 mdb into Oracle 7/8

[Quoted] It's hard!

I bet a lot of those error messages were for tables that had auto-incrementing sequences in them: since Oracle and MS data types don't [Quoted] correspond 1-for-1 (and auto-sequences are a classic no-corresponder!), you [Quoted] do get problems. Last time I did it, I went through the entire Access database renaming every column so that names were all in uppercase. Same [Quoted] for the tables themselves (otherwise, you have to enclose your table names [Quoted] in quotes when you start running queries - select * from 'emp' for example). [Quoted] Also, any autoincrementing sequence was replaced with a boring old number [Quoted] field (and triggers had to be hand-crafted afterwards to populate the relevant fields in Oracle). Quite hard work.

[Quoted] Oracle used to supply a conversion utility, but you had to pay for it, and [Quoted] I've forgotten what it was called, and don't know whether it is still current (someone here will know). I tried it once or twice: you still have [Quoted] to do quite a lot of work by hand afterwards, even so.

Regards
HJR "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message news:a3mmbq$d314$1_at_as201.hinet.hr...
> What is the easiest way to transfer Microsoft Access 2000 database into
> Oracle7 (7.3.4) or Oracle8i (8.1.7) database? I have tried Microsoft
> ODBC and original Oracle's ODBC drivers but without success! I only get
> some strange error messages! Sometimes, with some tables it works but
> not with all tables.
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
>
Received on Mon Feb 04 2002 - 20:52:20 CET