Use ERWIN. It can reverse engineer an access database and automagically
generate the Oracle DDL. (With some slight modification of course.)
> -----Original Message-----
> From: Rajagopal Venkataramany [SMTP:rajagopalvr_at_hotmail.com]
> Sent: Tuesday, May 16, 2000 10:37 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Moving from Access to oracle 8.0
>
> Radhika,
>
> Dump the contents from Access into a comma seperated format or a
> positional format (fixed record length) and use sql loader to
> take the details into Oracle.
>
> Regards
> Rajagopal Venkataramany
>
>
> ----Original Message Follows----
> Reply-To: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Date: Mon, 15 May 2000 20:37:02 -0800
>
> Radhika,
> I do not know ur requirements and integrity constraints. One Suggestion.
> Do
> not use ODBC connection. You will run into probs in table names, field
> names.
>
>
> Maheshwara Rao, L., Teki
> E Mail : teki01_at_mediaone.net
>
> -----Original Message-----
> Putumbaka
> Sent: Monday, May 15, 2000 11:06 PM
> To: Multiple recipients of list ORACLE-L
>
>
> All,
> currently we have a Access database with 25 to 30 tables. Client is
> planning to no longer use Access and to migrate the whole database to
> Oracle. What is the best way to move from Access to oracle 8.0. Any
> suggestions are appreciated.
> Thanks.
> Radhika.
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Radhika Rao Putumbaka
> INET: radhikaraop_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>
> --
> Author: Maheshwara Rao, L., Teki
> INET: teki01_at_mediaone.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Rajagopal Venkataramany
> INET: rajagopalvr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Tue May 16 2000 - 15:42:23 CDT
