Auto convert Jet SQL to T-SQL

Does anyone know of a program which will take my access queries and convert them automatically into SQL7 stored procedures
freedmanrpAsked:
Who is Participating?
 
Brendt HessConnect With a Mentor Senior DBACommented:
Try looking over this document:

http://msdn.microsoft.com/library/officedev/off2000/acconChooseHowToUpsizeApplication.htm

It discusses using the Upsizing Wizard to convert to SQL Server.  You should be able to use this for your queries:

"Queries   The Upsizing Wizard changes queries by converting them to either views or stored procedures and upsizing Access SQL syntax to use SQL Server SQL syntax. Select queries are converted to views. Sorted queries are converted to a combination of views and stored procedures to allow for nesting and sorting (Views can be nested but can't contain ORDER BY clauses; stored procedures can contain ORDER BY clauses but can't be nested). Parameterized queries, queries that depend on a parameterized query, and action queries are converted to stored procedures. You may need to manually convert queries that did not upsize (such as those that were nested too deeply). SQL Passthrough queries, data definition queries, and union queries are not upsized. "
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Nope
0
 
freedmanrpAuthor Commented:
Thank you very much.
0
 
Brendt HessSenior DBACommented:
You're quite welcome :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.