Upgrade 2005 Express to 2008 Std

• jpatt07

  Old Hand

  Points: 361

  More actions

  May 18, 2010 at 7:48 am

  #219024

  I need to upgrade our current SQL Express 2005 database to SQL Server Standard 2008 due to the 4 gig space limitation.

  What's the best method to upgrade?

  Can I go straight from 2005 Express to 2008?

  or should I

  first upgrade to 2008 Express then to 2008 Standard

  or

  upgrade to 2005 Standard then to 2008 standard.

  Microsoft SQL Server Management Studio Express:9.00.3042.00

  Microsoft Data Access Components (MDAC):2000.085.1132.00 (xpsp.080413-0852)

  Microsoft MSXML:2.6 3.0 4.0 5.0 6.0

  Thanks

  Jim

  Jim Patt

• Sedat Salman

  SSChasing Mays

  Points: 635

  More actions

  May 18, 2010 at 9:40 am

  #1168904

  most clean method to do this : do not upgrade

  detach databases from express edition and attach sql server 2008 and convert database

  compatibility level to 100

  but if you do not have enough time to do this

  directly upgrade sql express 2005 to standard edition

  but time will be almost equal for both methods

  http://www.sdtslmn.com