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

[Hans Aberg]

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