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?
J.R. SitmanIT DirectorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Qlemo"Batchelor", 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
J.R. SitmanIT DirectorAuthor Commented:
for 2014 can I use Express or do I need the full version?
0
Qlemo"Batchelor", 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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.