Hi all,
I could swear I saw something about the Impresario db needing to remain at a 90 compatability level even after you upgrade to SQL Server 2008, but of course I can't find it now. Hopefully I dreamt the whole thing because it would make me sad to not be able to use IntelliSense in SSMS 2008. Anyone else know?
Also, we have SQL Server 2008 Enterprise, but I'm inclined to upgrade to R2. Anyone heard if there are any Tessitura issues with R2 vs plain ole' 2008? And while I'm asking... anyone heard how TranScend fares in a SQL 2008 environment?
Thanks very much!
Nancy Sheleheda
Tessitura Application Administrator
The Pittsburgh Cultural Trust Consortium
Unknown said: I could swear I saw something about the Impresario db needing to remain at a 90 compatability level even after you upgrade to SQL Server 2008, but of course I can't find it now.
I could swear I saw something about the Impresario db needing to remain at a 90 compatability level even after you upgrade to SQL Server 2008, but of course I can't find it now.
You know, I have the same recollection, but can't find anything about it either. I know that Transcend, i.e. TPAU and TPAUARCHIVE dbs, must remain at 80 or 90 as per Intrix support.
Hi Nancy and Chris,
Actually, both impresario and impresario_cci dbs MUST be at a 90 comparability level: there are Tessitura (not custom ones) stored procs and db views which do not comply with SQL 2008 syntax. For instance some have the old SQL outer join operators *= and =*.
Thanks,
Simon Basyuk, DBA of Carnegie Hall
You are correct they need to remain at 90
By the way, Intellisense still works in 90 mode. And it's pretty neat.
There has been some confusion about the appropriate compatibility level for the v10 impresario and impresario_cci databases running in SQL Server 2008. When the SQL Server 2008 upgrade advisor is run against the v10 databases, some procedures and views do get reported as problems when run under SQL 2008 compatibility, but these procedures and views are obsolete and are no longer used by the application.
When upgrading to SQL 2008, it is strongly advised that the upgrade advisor be run to ensure that no custom procedures or views are incompatible with SQL 2008 compatibility mode, but the standard v10 Tessitura impresario and impresario_cci databases can successfully be running with SQL Server 2008 compatibility.
Bob