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
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--View this message online at http://www.tessituranetwork.com/Community/forums/p/11770/36387.aspx#36387 or reply to this message --This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Gawain Lavers f. 510.643.6707
Hi Shereen,
In theory, all of your stored procedures are prefixed with, “lp_” which is consistent with Tessitura’s naming conventions. However, given you posted this, I assume that means you are not confident those naming conventions were followed 100% of the time.
If I were in your shoes, I would attempt to essentially install a new Tessitura database to a SQL Server instance on a test server or workstation (I believe TIM in v12 simplifies deploying a new database but I haven’t tried it myself). That instance would have only Tessitura’s standard objects. Then, you can either use a fancy (not free) tool like Red Gate SQL Compare to compare the database schemas or run the query below in both your database and the standard Tessitura database, dump the results to text files, then use something like WinMerge to compare the contents of the files in order to find the differences.
select name
from sys.procedures
order by name
Thanks,
David
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Shereen Marino Sent: Friday, June 20, 2014 5:05 PM To: David Frederick Subject: [Tessitura Technical Forum] Custom Stored Procedures
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Hello Gawain,
Yes, I couldn't agree more on the naming convention as that's how I roll but I'm afraid it wasn't done in the past. I'll see if I can find the report. Thanks.
That's a great idea, David. We're on RAMP but I could check to see if we have a local server we could utilize.
Another thought... Someone in Tessitura support could probably dump a list of all stored procedures; that would be quicker than installing a database instance yourself. Best wishes as you track down your customizations!
Hello Gawain, Yes, I couldn't agree more on the naming convention as that's how I roll but I'm afraid it wasn't done in the past. I'll see if I can find the report. Thanks. ShereenFrom: Gawain Lavers <bounce-gawainlavers9512@tessituranetwork.com> Sent: 6/20/2014 7:10:38 PMThere ought to be a report that flags any customer procedures that are likely to have issues with the V12 changes, name escapes me at the moment. But more importantly, you're organization should really enforce a strong naming convention for all of your custom database objects. Ours, I believe, is pretty standard: "L+[object type, i.e. P for procedure, TR for reference table, etc.]+_CPSMA", CPSMA being our organization acronym. On Fri, Jun 20, 2014 at 5:03 PM, Shereen Marino <bounce-shereenmarino5792@tessituranetwork.com> wrote: 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--View this message online at http://www.tessituranetwork.com/Community/forums/p/11770/36387.aspx#36387 or reply to this message --This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you! -- Gawain Lavers f. 510.643.6707 --View this message online at http://www.tessituranetwork.com/Community/forums/p/11770/36390.aspx#36390 or reply to this message --This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
From: Gawain Lavers <bounce-gawainlavers9512@tessituranetwork.com> Sent: 6/20/2014 7:10:38 PM
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, David.
Thank you, Gawain.
Thank you, Wayne.