Re: Converting MS Access to Oracle

Brian M. Biggs wrote:
>
> Well, I was able to get Oracleizer for MS Access v1.03 (the latest
> version) from my Oracle representative. It works much better than the
> 1.00 version I had. It generated the scripts with only a few problems.
> The problems were fairly minor and easily corrected. Overall, it is an
> excellent utility. I highly recommend it. We only converted our
> database, so I can't comment on how it treats converting the application
> code.
>
> Unfortunately, the Oracleizer for MS Access is not redistributable.
> Contact your Oracle representative to get a copy.

A followup to my previous message.

The Oracleizer for MS Access v1.03 doesn't seem to convert the referential integrity from the Access database into Oracle. The tool generates SQL scripts for all other aspects of the database, but does not generate SQL scripts for referential integrity. I can get a report out indicating all of the relations, but still no SQL script. I suppose I can manipulate the report and generate the SQL myself, but it would be nice if they did that for you -- after all, it's part of the database! If anyone has found a way to do this, I'd like to hear from you.

The tool also had some problems generating correct SQL for complicated default value conditions on certain columns. It generated square brackets around some column names, converted a check for "-1" to TO_NUMBER(1), and truncated the last condition in a complicated check.

Finally, I previously stated that the tool was not available to the general public. I was incorrect. Go to http://tiburon.us.oracle.com/odp/index3.html and download the MS Access Utilities (1-4) and the MS Access White Paper (in PDF format). The utilities disk will install v1.02 of the Oracleizer for MS Access. If you want the latest version (1.03), I guess you have to contact your Oracle representative.

Regards,
Brian

-- 
Brian M. Biggs				mailto:bbiggs_at_cincom.com
Cincom Systems, Inc.			voice: (513) 677-7661
http://www.cincom.com/