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 BursnallInformation Systems Manager Royal Opera HouseCovent Garden, London WC2E 9DDTelephone: +44 (0)20 7212 9408Email: keith.bursnall@roh.org.uk Website: www.roh.org.ukYouTube: www.youtube.com/royaloperahouseJoin us on Facebook: www.roh.org.uk/facebook
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!
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:
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.
Yes, SQL 2005 (running on Windows Server 2003).
Sorry for confusion.
K