Hello everyone,
I am quite new to the network as I have just recently started working with Tessitura here at the theatre but I was hoping for some advice from the fellow community!
We are currently in the process of planning our upgrade from SQL Server 2005 to SQL Server 2008, and was thinking of migrating the database from 05 to 08, starting from a blank server. This way we should minimise downtime and know how to setup from scratch if we ever need to again in the future.
Has anyone experienced issues when migrating from 05 to 08? Is there any particular pitfallls that we should look out for?
Also, as we are building our 'new' server from scratch, if we upgrade the components to meet the required standards for Tessitura v11, will these still be compatible with v10? I.e. the IIS gateway and SSRS?
Thanks for any help on this!
Scott
I just conducted our 05-08 (R2) upgrade. What I did was take down our test environment, migrate the live databases to the test environment and repoint all of the services at the test environment machines (hosting the live databases) and then updated the master ini file to point to this test environment so all of the users were now using the live database hosted on the test server. Then during the day I upgraded the SQL server as an inplace upgrade. Then that night moved the databases back, repointed all the services and then updated the ini file again to point all the users back to the live environment. It was a little tricky juggling everything but I feel like it went very smoothly. I had no issues doing the upgrade and we have been live with it for about 2 weeks.
Consequently, later, our test environment became corrupted and I had to install SQL server '08 as a new install and migrate the databases over. I also had no problems with that install type either.
Hope this helps...
Sean Pinto