Re: Converting Access 97 to Oracle 9i

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 10 Jan 2005 07:06:23 -0800
Message-ID: <41e30701$1_2@127.0.0.1>

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
> ------------

If they have it would likely write some of the least scalable and worst performing code imaginable. You are talking about moving from a product that barely has a right to call itself a database to a large commercial RDBMS. Any SQL you might get out of Access97 would be worthless or worse. You most likely should not even use the same table names.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Received on Mon Jan 10 2005 - 09:06:23 CST