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
Hi Scott,
JD Short, from Network Support posted in the Support Spotlight blog about server moves, which might be helpful--it's a collection of pointers to resources on this site; you can find the post here.
Best,Todd
Tessitura Network Webmaster
Thanks for the help guys, its really appreaciated!
I'll check out the link now.
I too am new to the network and we migrated from SQL 2005-2008 and the main issues we ran into were .ini files pointing to the wrong resource. We detached the 2005 made a copy and reattached to the 2008.
We’re pretty much in the same boat right now. We’re setting up brand new W2K8 servers w/ SQL2008. Will move the existing 2005 DB onto the new server. Already have this working in test. Basic server setup & config stuff is not too bad. Indeed I agree, the .ini files and other startup stuff needs a bit of attention. Backup plans & jobs too. I am happy to share our experiences.
…Dave
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of John Brandt Sent: Thursday, January 12, 2012 4:09 PM To: Vivino, David Subject: Re: [Tessitura Technical Forum] SQL Server 2008 Upgrade
From: Scott Whitehouse <bounce-scottwhitehouse8657@tessituranetwork.com> Sent: 3/30/2011 3:37:46 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!