I don't want to sit here and re-engineer Access SQL to SQL Server ANSII all day. Is there a cool that will convert a sql statement if you past it in to ANSII? Or what other techniques can make my life easier in the process if you have any up your sleeve?
Also, is there anything in .NET or even SQL Server 2005 to help convert SQL statemetns from Access to SQL Server?
AFAIK, there are no tools to do this. If you however write your query using the ODBC canonical syntax then the ODBC/OLEDB driver can convert the syntax to the native data source automatically. Of course, this only applies to applications that you code. For example, Visual FoxPro allows you to create queries like this on the client-side that can be run against different data sources.sqlsql
No comments:
Post a Comment