Re: Migrate Data from MSAccess to Oracle

Mark C. Stock wrote:

> "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
>
>

I see two issues mentioned -- character set conversion and cross-platform schema conversion. There are some tools which can copy (translate) table definitions from Oracle to MS and the other way as well, written using Perl DBD::Oracle, JDBC, and other clients.

As for the charset conversion, I'm only familiar with the Oracle side, so no help here for that.

--Mark Bole Received on Wed Sep 22 2004 - 20:31:49 CDT