Re: Migrate Data from MSAccess to Oracle

From: §§§ Blue Ice §§§ <blue_ice_§§§_at_©®.com>
Date: Mon, 27 Sep 2004 11:37:24 +0700
Message-ID: <2rpjo4F1d73laU1@uni-berlin.de>

"Praveen" <spraveen2001_at_yahoo.com> wrote in message news:98d8ec76.0409230116.785a4194_at_posting.google.com... > "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<KvOdnc2pgJvgQMzcRVn-hQ_at_comcast.com>...
> > "Greg Forestieri" <gforestieri9_at_yahoo.com> wrote in message
> > news:6a8cdd95.0409221114.133d7e12_at_posting.google.com...
> > | spraveen2001_at_yahoo.com (Praveen) wrote in message
> > news:<98d8ec76.0409220553.36659419_at_posting.google.com>...
> > | > Hi All,
> > | >
> > | > We have an application in french language at client site which is
> > | > using MS-Access as DB. Now we redesigned the application to web
based
> > | > using java and Oracle as the backend DB. Now they want to load data
in
> > | > MS-Access db to oracle db. I'm using UTF8 db in oracle. Oracle DB
and
> > | > MSAccess DB are not much syncronized with tables/columns. Can anyone
> > | > tell me how can i approach for data migration?
> > | >
> > | > Thanks in advance,
> > | > Praveen
> > |
> > |
> > | Look into "ODBC"

> >
> > at some point oracle had an MS-Access Migration Assistant, but I'm not
sure
> > if that is still around or how good it is/was

> >

> > however, as Greg mentioned, ODBC is a very good option -- you can attach
> > Oracle tables to MS-Access and then use simple Access append queries to
copy
> > (insert) access data into Oracle tables

> >

> > i would suggest creating oracle tables that are a mirror image of each
> > access table and just move the data as is, then use PL/SQL procedures to
> > transform these 'staging' tables to the production tables

> >

> > ++ mcs

>
> Thanks All for the response,
>
> As Greg mentioned using ODBC and attaching oracle tables to MS-Access
> is good option. I think for this we may have to write Macro in
> MS-Access DB to load into oracle table. as table/column in both the
> dbs' are not fully synchronized. But, client need a standalone program
> which takes the data from access mdb file and load into oracle tables.
> While loading we may have to handle different conditions. So, i think
> creating oracle tables that are a mirror image of each
> access table and just move the data as is, then use PL/SQL procedures
> to
> transform these 'staging' tables to the production tables will be
> helpfull.
>
> Thanks,
> Praveen

can also use TOAD for migrating the data from MS-Access to Oracle. Received on Sun Sep 26 2004 - 23:37:24 CDT