Hey folks,
We are shifting out SelfHosted Tessitura to Hosted Services (nee RAMP) and in the run up we really need to have a good look at the various, and many customisations that have been put in place over the last 10 years.
Does anyone have advice, tips and/or a customisation leger/doc that has helped them in the past?
H
I don't have a document, but I do have a series of queries that I use for looking at what we need to test on upgrades. The queries check for any custom items in Tess. It uses the system catalogs to search for custom stored procedures, functions, tables, triggers, and views based on naming conventions (L*). Pretty simple, but it helps me focus on where I need to test.
That sounds awesome! Are you willing to share? If so, I'm at mdorsey@spoletousa.org.
Thanks,
Michael
Would 100% take this also, Carol, if you're willing to share! nlegrand@rwb.org
Would love to have a look at this. Thanks Carol. hwilder@sydneytheatre.com.au (or of course heath@heathwilder.com)
Hi Carol,
That is amazing! if you are okay sharing may I also get a copy. asma.ahmed@acttheatre.org
I'd love to dig through this, too, Carol - thanks in advance! jreynolds@clevelandorchestra.com
Mostly what I do is just query the system catalogs. You can learn about them here: https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-all-objects-transact-sql?source=recommendations&view=sql-server-ver16
Here's an example to find local tables:
select * from sys.all_objects where name like 'L%' and type = 'U' -- user table
order by name
You can query gooesoft_report to find reports. (Note: This table includes both the reports that come with Tessitura as well as locally created ones.) The reports can be SSRS or Infomaker. SSRS reports (.rdl files) can be found in the "Report Manager" in reports and T_DEFAULTS will tell you what Infomaker .pbl or .psr files you have.
You can also look at TR_LOCAL_DATA and TR_LOCAL_PROCEDURE in System Tables to see if anything has been set up there. TR_CUSTOM_TAB will show you what tabs have been set up and what .pbl or URL they point to.
Note: This is not an exhaustive list. Your organization may have customizations in other areas....