Re: URGENT: access to oracle conversion

From: <jean_marc_guicheney_at_my-dejanews.com>
Date: Thu, 04 Mar 1999 17:03:56 GMT
Message-ID: <7bmedk$lhs$1@nnrp1.dejanews.com>

If you dump the data, do it in ascii mode and use sql*loader... But a better way is to attache oracle tables inside access and it works as if all tables were in access. It must be easy, at this point, to move the data from the old acces tables to the brand new oracle tables.

In article <7bljc1$qva$1_at_nslave1.tin.it>, "Amy Davidson" <davidson_at_spectec.it> wrote:
> DBA's and Developers,
> I am starting a project to convert an access db to an oracle db.
> I have never used access and don't know the structure of the
> access db . I know oracle really well as I am a dba for 5 years
> I know the structure of the oracle db.
> Oh,,,I have a week to do this! I just started this job too.
>
> I would like to write scripts to put the data from access to oracle.
> Any ideas on the scripts. This is what I'm thinking...is it crazy.
> 1) Dump the data from access to files.
> 2) Write SQL scripts in Oracle to read the files
> and populate the database.
> Is this the correct way to go about this?
>
> How do I determine the structure of the access db.
>
> General comments are welcome and any warnings of
> problems I might have with access?
>
> Thanks,
> Amy
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 04 1999 - 11:03:56 CST