Re: Converting Access 97 to Oracle 9i

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 10 Jan 2005 18:03:07 +0100
Message-ID: <crucej$483$1@news5.zwoll1.ov.home.nl>

michaelgooding_at_yahoo.co.uk wrote:
> We will be using the nigration workbench to convert the database to
> Oracle, but presumably we need to scan all the SQL as well. I don't
> suppose someone's made life easy for us by highlighting Access-specific
> SQL constructs and their Oracle equivalents ?
>
> Mike Gooding
> ------------
>

You will be using OMWB... good - then check out it's capabilities. OMWB will not just highlight, it will translate. And there's a potential danger: Access SQL will remain Access (TSQL?) SQL. It will never use the full potential of Oracle as a database, and pl/sql as a programming language.

Reconsider if it would not be more beneficial to rewrite the app in decent sql.

-- 
Regards,
Frank van Bortel

Received on Mon Jan 10 2005 - 11:03:07 CST