RE: from ms access SQL syntax to SQL Server SQL sysntax

[Luis Hernandez]

We already have a utility that converts MS Access SQL statements to
Oracle. It is written in VC++ and Bison. Now, I have to add support to
SQL Server. The code is complex so I'm trying to avoid coding. Accuracy?
It has to work.

Thanks for your help.

-----Original Message-----
From: Hans Aberg [mailto:address@hidden
Sent: Friday, June 06, 2003 1:23 AM
To: Luis Hernandez
Cc: address@hidden
Subject: Re: from ms access SQL syntax to SQL Server SQL sysntax

If the syntax differences between input and output are very small, as it
seems to be in your case, then a text processing program like awk, Perl,
M4, etc, might do the trick. Perhaps the newsgroup comp.compilers or its
FAQ, published there monthly, might help.

A parser generator like Bison is suitable if you want to make a very
correct parsing of the whole grammar. But I suspect you are looking for
some quick conversion hack where this degree of accuracy is not so
important, right?


At 16:16 -0700 2003/06/05, Luis Hernandez wrote:
>
>
>I m desperately looking for a utility to convert MS Access SQL
statements
>to SQL Server OR from Oracle to SQL Server.
>
>
>Example:
>
>
>From (Jet):    SELECT Choose (T1.SurceType, T1.Name, T2.Name)  FROM
Table1
>T1, Table2 T2
>
>
>To (SQLServer):  SELECT Case (T1.SurceType WHEN 1 THEN T1.Name WHEN 2
THEN
>T2.Name) FROM Table1 T1, Table2 T2
>
>
>If you know one, let me know please.
>
>
>
>
>
>
>
>_______________________________________________
>address@hidden http://mail.gnu.org/mailman/listinfo/help-bison