Hello everyone,
Does anyone know of a way to identify custom stored procedures? We're moving to V12 and I need to identify custom procs and determine if they need to be modified for the upgrade. I've checked the website but I don't see a list of standard stored procedures that I could compare against the procs that exist in our DB to help me identify those that are custom. I think our organization has been on Tessitura since V3 and there have been many DBAs over the years so I'm going to have my work cut out for me. Any suggestions you have would be greatly appreciated.
Thank you,
Shereen
If you go onto TASK and download the v12 upgrade kit, in there is tessitura installation manager tool (TIM). If you've a sql/sql express database available on your network, you can use that tool to deploy a new blank database to there. In theory you should have all the tessitura written tables/functions/stoped procs and get your list from there
Hope this helps
Thank you, Wayne.