Currently our Tessitura server has reached its limit in disk space. I am unable to upgraded to SQL 2008. So we have decided to purchase a new server for Tessitura.
My question is what is the best way to migrate the data over to the new server? Install SQL 2005 and then restore the databases then upgrade to SQL 2008? Do a fresh install of SQL 2008 and then restore the database from the old server?
Thoughts or suggestions?
Thanks,
Jeff
If it were me, I would skip the db upgrade, copy the Tessitura data to a cleanly installed 2008R2 server, and migrate from there.
Hi Jeff,
I agree with Chris - there is no reason to install SQL Server 2005 on the new server. Just restore backups of your databases from SQL Server 2005 to your new SQL Server 2008 server once you are ready. I recently did this from one of our old SQL Server 2005 servers to a new virtual server with SQL Server 2008 R2.
There are additional configuration steps you will need to do on the new database server after you restore your databases. Specifically, look at the Tessitura Database and Client Installation Instructions document, steps 11 through 18. in regards to step #11, you can find Utilities.sql on TASK in the Version Upgrades and Patches workspace in solution #32 (Tessitura Optional Components).
Note that I'm replying under the assumption that you are referring to impresario and impresario_cci databases. There is additional work needed if you have additional databases, like T-Stats databases, to migrate. I hope this helps!
Thanks,David
AWESOME! Thanks for the replies everyone! This helps alot!