Re: Converting Access queries to ANSI SQL
From: Peter Dudley <peter.dudley_at_its.maynick.com.au>
Date: 1997/02/12
Message-ID: <01bc1931$5d3b71c0$3419030a_at_inmarsat.its.maynick.com.au>#1/1
Date: 1997/02/12
Message-ID: <01bc1931$5d3b71c0$3419030a_at_inmarsat.its.maynick.com.au>#1/1
I am probably off the planet, but is there not a switch the causes ODBC to log the SQL it has generated?
-- Peter Dudley Interactive Innovations P/L interino_at_ozemail.com.au [Quoted] Tim Nutman <timn_at_sdsapps.co.uk> wrote in article <3301C6DC.266F_at_sdsapps.co.uk>...Received on Wed Feb 12 1997 - 00:00:00 CET
> I am currently converting a MS-Access database into Oracle.
> I am having a problem with re-writing all the MS-Access queries
> into ANSI SQL for the Oracle version of the database. The problem
> is two-fold.
>
> Firstly it is taking a long time having to manually re-write the
> queries.
>
> Secondly I am having problems re-writing some of the more
> complex joins that are in Access into Oracle - this is due to
> Access's Jet Engine DB having INNER, LEFT and RIGHT Joins - I
> understand what these joins are and I am having success in translating
> them into ANSI SQL but I am not confident when it comes to
> complex nestings of these joins.
>
> So basically is there any software that can translate Jet Engine DB
> queries (Access queries) into ANSI SQL? Is there any definitive
> help in terms of guidlines for translating them? Basically help!
> I have been trawling through books and help files and all to no
> avail (and if anyone suggests trying exporting the queries from
> Access via ODBC into Oracle then please don't as I have already tried -
> it doesn't work - Access runs the query first then exports the
> resulting table)
>
> I hope someone can help
>
> Regards
> Tim Nutman
>