• Replies 4 replies
  • Subscribers 338 subscribers
  • Views 6 views
  • Users 0 members are here
Related

Upgrading SQL Server 2003 (Enterprise) to SQL 2008 (Standard)

Keith Bursnall
$organization

Hi,

Getting ready for the upgrade of Tessitura to version 10 has also alerted us to the SQL Server upgrade in March. We do have a problem however, and would be grateful for any input anyone has to offer.

The difficulty we have is upgrading SQL Server 2003 (Enterprise) to SQL 2008 (Standard).

Has anyone else been through this process?

All advice, gratefully received.

Keith Bursnall
Information Systems Manager
 
Royal Opera House
Covent Garden, London WC2E 9DD
Telephone: +44 (0)20 7212 9408
Email: keith.bursnall@roh.org.uk
 
Website: www.roh.org.uk
YouTube: www.youtube.com/royaloperahouse
Join us on Facebook: www.roh.org.uk/facebook

Parents
  • $organization

    Hi Keith -

    It's my understanding (and other IT people jump in if I am wrong) that Microsoft considers the path from Enterprise to Standard a downgrade (no matter if you are going to the "next" version of SQL) and will not allow you to do it as an upgrade. 

    The only option in MS's great brain is to do a clean install to Standard. Which is a big ewww.  This was true for the 2000 -> 2003 path, I'm assuming it is true for 2008. Here's a link to the MS upgrade path doc:

    http://msdn.microsoft.com/en-us/library/ms143393.aspx

    You can see that the only supported options from Enterprise are 2008 Enterprise or Datacenter. In other words, once you go Enterprise, there's no going back easily. :P

    Someone else might know of workarounds, but that's my understanding of the situation. When we ran into this for the 2000->2003 upgrade we had to install a clean copy of 2003 Standard on another server and migrate our Tessi to that server. Fortunately, it was when we were already upgrading the server.

    HTH,

    Heather
    Seattle Rep

Reply
  • $organization

    Hi Keith -

    It's my understanding (and other IT people jump in if I am wrong) that Microsoft considers the path from Enterprise to Standard a downgrade (no matter if you are going to the "next" version of SQL) and will not allow you to do it as an upgrade. 

    The only option in MS's great brain is to do a clean install to Standard. Which is a big ewww.  This was true for the 2000 -> 2003 path, I'm assuming it is true for 2008. Here's a link to the MS upgrade path doc:

    http://msdn.microsoft.com/en-us/library/ms143393.aspx

    You can see that the only supported options from Enterprise are 2008 Enterprise or Datacenter. In other words, once you go Enterprise, there's no going back easily. :P

    Someone else might know of workarounds, but that's my understanding of the situation. When we ran into this for the 2000->2003 upgrade we had to install a clean copy of 2003 Standard on another server and migrate our Tessi to that server. Fortunately, it was when we were already upgrading the server.

    HTH,

    Heather
    Seattle Rep

Children
No Data