Re: Tool to convert SQl queries to oracle or vice versa

Hi

If you can, just write standard ansi92 SQL queries because its understand by both DB

don't use product's function
like DECODE for Oracle or IIF for SQLServer

hth
Chris

venkateswarlut_at_cisindia.com (Venky) wrote in message news:<31fe732d.0201172145.2a714d40_at_posting.google.com>...
> I am writing a VB application which has to support both SQL server or
> Oracle depending on the installation choice.
>
> I am looking for a tool which can convert SQL querieis to Oracle or
> vice versa...
>
> Any other ideas...
>
> -Venky
Received on Tue Jan 22 2002 - 15:34:43 CST