[thelist] Converting Access to Oracle?

Adam Patrick wrote:

> The good news: Oracle has a pretty cool migration utility which was used
> to move Evolt's Access data to Oracle pretty easily.

Ya, this took me and adam about 2 weeks to figure out how to do. Lucky
for you, we figured most of it out :) If you have a simple access DB,
you're in luck.

You can either: 
1.) Define an ODBC connection to your Oracle DB, and 'Save As' in access
to an odbc datasource(there are some probs with this, make sure all your
column and table names are *upper case*) which will work for the easy
stuff

2.) Oracle has a pretty slick Migration Wizard type program.
http://technet.oracle.com this ended up hosing my ODBC drivers, but it
might work for you :)

3.) Save the Access DB as a flat file and use sqlloader to import it
into Oracle.

If you can get away with number 1, you're in good luck.. Its usually the
easiest.
 
> The bad news: The migrator put memo data into a CLOB field in Oracle
> which is not yet supported by ColdFusion so we had tons o' fun moving
> CLOB data into a LONG field.
> 
> In other words: No memos, No problem. Know memos, Know Adam.  I have
> some documentation about converting that data if you want it.
> 
> Oh, and the other bad news is:  If you have any Access specific SQL,
> you're going to have to convert it.  It can be pretty messy but then
> again it can be not that bad if you write mostly standard SQL.

Ya, especially watch out for wacky date formats.. Access has some wierdo
date formating, which Oracle will pretty much puke on. Before you export
to access.. do a Search and replace on wierd stuff before you do the
ODBC export.

And shout if you have probs.. No one should have to go through what we
did again ;)

.djc.