• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 27
  • Last Modified:

Can an SQL2008 Server database be upgraded?

We have a SQL2008 Server with some very important databases in it.  Can it be upgraded to 2012 or 2014 without any data loss?
0
J.R. Sitman
Asked:
J.R. Sitman
2 Solutions
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The answer is "yes". Attaching the database files or restoring from a backup to 2012 resp. 2014 instance will auto-upgrade, keeping the compatibility level of 2008. The compatibility level can then be raised if your applications can cope with the new features.
0
 
J.R. SitmanIT DirectorAuthor Commented:
for 2014 can I use Express or do I need the full version?
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The individual DB size and how much RAM needs to be used for good performance determines which edition you choose, and whether you need a particular (high-level) feature.
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
J.R. SitmanIT DirectorAuthor Commented:
The size of the two databases is 12 meg.  Not sure how much RAM is needed.  It is a Blackbaud accounting database
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
You need to check with the vendor whether this migration will cause any issues with the application. If its good from the vendor, you can upgrade it to SQL 2012 / 2014. Express edition is fine as your databases  are under 10GB
0
 
Olaf DoschkeSoftware DeveloperCommented:
As Qlemo already noted, it's not just a decision about size or number of users, some features are not available in Express.

Bye, Olaf.
0
 
J.R. SitmanIT DirectorAuthor Commented:
Thanks
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now