SQL Server 2008 Upgrade

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 Reply Children