[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-dev
Subject:    RE: Converting database from access to oracle
From:       "Bushel.Pierre" <bushel () niehs ! nih ! gov>
Date:       2000-12-31 12:50:27
[Download RAW message or body]




 Oracle has a Microsoft Access to Oracle migration assistant which
will perform the conversion.  I used it and it works well.  It
requires Access 97 and may rename some columns, etc if they violate
Oracle naming convention.  Therefore you'll have to change web
application code.  Also if you are using a middleware product like
ColdFusion some of the proprietary fuctions aren't supported by
certain Oracle native drivers.


Hope this helps,

Pierre Bushel
Bioinformatics Manager
NIEHS Microarray Center


-----Original Message-----
From: Sameer Adhyapak
To: dbi-dev@isc.org
Sent: 12/29/00 2:20 AM
Subject: Converting database from access to oracle




Hello,
 

Ours is a small team which is developing an application where we will
need to
convert the access database to the oracle database every now and then.
Is
their any short cut method for this. A step by step explanation will
be
highly
appreciated.


____________________________________________________________________
Get free email and a permanent address at
http://www.netaddress.com/?N=1


----------------------------------------------------------------------
--
------
DBI HOME PAGE AND ARCHIVES:
http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit:
http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the
web
page,
please send mail to dbi-dev-request@isc.org with the subject line of:
'unsubscribe'.
----------------------------------------------------------------------
--
------


------------------------------------------------------------------------------
DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web page,
please send mail to dbi-dev-request@isc.org with the subject line of:
'unsubscribe'.
------------------------------------------------------------------------------

[prev in list] [next in list] [prev in thread] [next in thread]