Convert from ACCESS 2007 to SQL 2008

Hi,

What is the best way to convert it? thx
mcrmgAsked:
Who is Participating?
 
kenwagersConnect With a Mentor Commented:
The easiest way is to create an empty database in SQL Server, and then select Import from the database context menu.  Follow the wizard steps, and it will move all the data and structures into SQL Server.

Note that you may wish to define the database first (improving the database schema) and then importing the data through the same path, mapping the Access tables to the SQL tables.

This doesn't address any application level issues.
0
 
mcrmgAuthor Commented:
will it import queries from access to sql?  I remember there was a upsize function in access 2000.  I am not sure if it still exists in 2007..thx
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.