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.