[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: from ms access SQL syntax to SQL Server SQL sysntax
From: |
Hans Aberg |
Subject: |
Re: from ms access SQL syntax to SQL Server SQL sysntax |
Date: |
Fri, 6 Jun 2003 10:22:54 +0200 |
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