• 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

    Do you mean SQL 2005? We are currently running 2005 and are also planning the upgrade to 2008 but haven't executed anything yet. Are you trying an inplace upgrade or a migration? I'll be very interested to continue following this thread.

    Thanks!

  • $organization in reply to Nathan Campbell

    OK.  I may be wrong here because this is not something we have tried and I am not a SQL expert.  If you think you may want to try this I would strongly suggest some trials in a test environment first but I think you could probably do this:

    • Download the 180 day trial of SQL 2008 Enterprise
    • Upgrade your SQL 2005 Enterprise to the 2008 trial.
    • Confirm everything is working then detach the databases
    • Uninstall the SQL 2008 Enterpise trial and install the SQL 2008 standard version
    • Re-attach your databases.

    This should achieve the DB upgrade without too much scripting required on your part and in the end you will have a licensed SQL 2008 standard install.

Reply
  • $organization in reply to Nathan Campbell

    OK.  I may be wrong here because this is not something we have tried and I am not a SQL expert.  If you think you may want to try this I would strongly suggest some trials in a test environment first but I think you could probably do this:

    • Download the 180 day trial of SQL 2008 Enterprise
    • Upgrade your SQL 2005 Enterprise to the 2008 trial.
    • Confirm everything is working then detach the databases
    • Uninstall the SQL 2008 Enterpise trial and install the SQL 2008 standard version
    • Re-attach your databases.

    This should achieve the DB upgrade without too much scripting required on your part and in the end you will have a licensed SQL 2008 standard install.

Children
No Data