Solved

SQL express 2005 to SQL Express 2008

Posted on 2013-01-09
6
547 Views
Last Modified: 2013-01-11
trying to fix a mess.

I have a windows 2008 r2 64x box with WSUS and Trackit that are using SQL express 2005 for the database manager. yes i know this is not supported. I know nothing about sql so you will have to walk me through this if possible.

what i want to do. install SQL Express 2008 on same Server and move/upgrade the databases to 2008 and remove 2005. sounds simple enough but i know nothing about sql.

is it possible. do you need more info? the trackit program only supports sql to version 2008 so going to 2010 or 2012 is not an option.

Thanks

Corey
0
Comment
Question by:Coreyg13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38761472
>>only supports sql to version 2008 so going to 2010 or 2012 is not an option. <<
There is no SQL Server 2010.  

Do you want to install the Express Edition of SQL Server 2008 or SQL Server 2008-R2?
Are you installing it on a new server or the same one as the SQL Server 2005?
0
 
LVL 2

Author Comment

by:Coreyg13
ID: 38761483
Yes the express version of 2008 r2 and yes install to same server.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38761584
Then it should be as simple as doing an in-place upgrade as it appears that this route (SQL Server 2005 to SQL Server 2008-R2) is supported.  See here:
http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx
0
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 38761775
Just run the SQL Server installer and  check the option "Upgrade from SQL Server 2000/2005/2008"

and follow the steps.
0
 
LVL 2

Author Comment

by:Coreyg13
ID: 38762836
So I ran the install and chose the upgrade option and got an error message. i was able to install a new instance of 2008 r2 though. is there a way to move the databases to the 2008 instance and upgrade the databases?
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 38765620
i was able to install a new instance of 2008 r2 though. is there a way to move the databases to the 2008 instance and upgrade the databases?
Restore the SQL backups from the old instance in the new instance.
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.

739 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