Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 564
  • Last Modified:

SQL express 2005 to SQL Express 2008

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
Coreyg13
Asked:
Coreyg13
  • 3
  • 2
1 Solution
 
Anthony PerkinsCommented:
>>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
 
Coreyg13Author Commented:
Yes the express version of 2008 r2 and yes install to same server.
0
 
Anthony PerkinsCommented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Alpesh PatelAssistant ConsultantCommented:
Just run the SQL Server installer and  check the option "Upgrade from SQL Server 2000/2005/2008"

and follow the steps.
0
 
Coreyg13Author Commented:
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
 
Anthony PerkinsCommented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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