Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Migrating from MS Access to oracle

Re: Migrating from MS Access to oracle

From: KENNETH JANUSZ <kjanusz_at_att.net>
Date: Wed, 09 Apr 2003 09:13:41 -0800
Message-ID: <F001.0057E0DB.20030409091341@fatcity.com>


You may want to migrate to 9i.

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

> 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).
>

-- 
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).
Received on Wed Apr 09 2003 - 12:13:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US