• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 12 views
  • Users 0 members are here
Related

SQL Server 2008 Upgrade

Scott Whitehouse
$organization

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

 

Parents
  • $organization

    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

     

    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. 

    From: Scott Whitehouse <bounce-scottwhitehouse8657@tessituranetwork.com>
    Sent: 3/30/2011 3:37:46 AM

    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

     




    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!

Reply
  • $organization

    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

     

    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. 

    From: Scott Whitehouse <bounce-scottwhitehouse8657@tessituranetwork.com>
    Sent: 3/30/2011 3:37:46 AM

    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

     




    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!

Children
No Data