[Last Call] Learn how to a build a cloud-first strategyRegister Now


SQL syntax

Posted on 2009-02-11
Medium Priority
Last Modified: 2012-05-06
Does anybody know of an online tool which can convert MS Access SQL syntax into SQL 2005 Server syntax
Question by:Mr_Shaw
LVL 14

Accepted Solution

Emes earned 2000 total points
ID: 23614017

here is a snipit from  http://www.tek-tips.com/faqs.cfm?fid=2935

The Access to SQL Server upsizing wizard is the best way to start.  There's a different version for each version of Access.  

The Upsizer that comes with Access '97 does a pretty good job but won't convert parameterized queries.  This leaves you in the position of having to code them yourself.  I've written code to convert these but moving up to the Access 2000 upsizing wizard is another solution.

The Upsizer that comes with Access 2000 converts parameterized queries into stored procedures.  For this reason it may be worth converting your Access '97 db to 2000 first and then using this Upsizer.

I've also written an article on converting Access database to SQL Server.  It's from 1999, before Access 2000 was available but much of it is still relevant. It's available for free at http://www.NovickSofware.com/Articles.htm

One other thing:  I've found that it's a good idea to convert in multiple steps.  First, Upsize the database schema, then move the data.  The upsizer sometimes chokes on some of the data movement.  I generally use DTS to move the data, not the upsizer, but sometimes you can even use Access copy and paste to do the job.


Author Closing Comment

ID: 31545631
Emes... how true!

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
Integration Management Part 2
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question