Can I upsize an Access 2007 database to SQL Server 2012?

I get an error message that indicates that I cannot do this but I just want to be sure I'm not missing anything.  If I can't upgrade to SQL Server 2012 what version can I upgrade to?

--Steve
SteveL13Asked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
Define 'upsize'.

In SQL 2012 you can right-click on a databse, go to Tasks: Import Data..., and follow the wizard to import from Access 2007.   This will import the tables, not sure if you have to re-create relationships.

Once that's done, go back to your Access app and link tables, change the table names to your current tables / delete the current local tables, then test your app to make sure it works.
0
 
btetlow-expertCommented:
If you can clarify what the problem is with the Access 2007 -- What exactly is it telling you that you cannot do?
0
 
SteveL13Author Commented:
When I explore to my back end database and right-click on it I do not see an option to Tasks: Import Data.  I must be missing something.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
btetlow-expertConnect With a Mentor Commented:
Depending on your version of SQL, you may need to use a conversion utility that's available at Microsoft.

Last I used it, it was free, but you had to go thru the usual validation hoops to get to it online.

I'm just starting to use SQL 2012, so I can't speak to that, but from what I was able to find...

Create a database on the SQL 2012 instance. Right click on that database and choose tasks/import data. Choose an access database as the source. edit the mappings so that it fits what you like, and import.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
<Potentially stupid question>
Which version of SQL Server do you currently have?
If you don't have version x, you can't upsize to version x.
0
 
SteveL13Author Commented:
I am using SQL Server 2012 Express
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.