Re: Migrating from MS Access to oracle

Once you get the data into intermediate Oracle tables you can use SQL*Loader to load the data into the actual Oracle tables that will be used by the application. If you are going to go this route I recommend O'Reilly's book: SQL*Loader: The Definitive Guide.

Ken Janusz, CPIM

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, April 09, 2003 10:28 AM

> Sam - I haven't done this, tried to stay away from Access. What I've seen
> posted from those who have, create equivalent tables in Oracle to match
the
> Access tables, then use Access to connect to these tables. Then you can
> simply copy records from the Access tables into the Oracle tables. Access
> can create the tables in Oracle, but that isn't a good idea because Access
> will tend to use goofy data types like LONG. My suggestion would be to use
> this method to get the data into some temporary tables in Oracle, then
move
> the data around into your permanent tables using SQL. Maybe someone with
> Access experience will post better ideas.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Wednesday, April 09, 2003 12:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi List,
> I would like your views on migrating from Microsoft
> Access to Oracle8i.
> Folloing is one of the scenarios that we might come
> across.
> There are columns in table need to insert as a row.
> e.g. Access Table1 has column col1,col2,col3
> we need to insert those col1 as row1 ,col2 as row2 of
> Oracle table.
> 1.Can this be done using sql loader ?
> 2.What are the typical limitations u experienced of
> sql loader ?
> 3.What are other ways to migrate (i.e. other than sql
> loader)and also validate migrated data.
>
> I will appreciate any comments and views.
>
>
> Platform:Oracle8i,MS Access 2000
> O.S.:Win2000.
>
>
> Thanks
> Sam
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms, and more
> http://tax.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: sam d
> INET: sam_orafan_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: KENNETH JANUSZ
  INET: kjanusz_at_att.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).