| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Migrating from MS Access to oracle
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
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).
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 - 10:28:49 CDT
 |
 |