How to Shift Performances into Different Production Seasons?

You'll need someone with access to SSMS (SQL). Here is the script I use.

/*
***FIND and UPDATE the Production Season on a given Performance***
Created by Michael Dorsey MN Zoo
Based on Monthly_Convert_to_Membership - Neil Cole
--Has an Output statement so that it displays the results before committing the transaction.

--Amended by Neil Cole 5/17/21
--Make sure the new Prod_Season and Season(s) have already been created.
--Make sure that you know how the mapping results should look before running.
--Made it more general so as to do all perfs in a production season with a specific performance name.
--Added a From statement so the update statement could do a join with T_INVENTORY.description.
--
*/

DECLARE @ReplaceProdSeason TABLE (perf_no INT, old_prod_season INT, new_prod_season INT, old_season INT, new_season INT)
DECLARE @OldProdSeason int = 34619
DECLARE @NewProdSeason INT = 25511
DECLARE @NewSeason int = 222
--DECLARE @PerfNo int = 31966

Begin TRANSACTION A

update T_PERF 
       

SET T_PERF.prod_season_no = @NewProdSeason, T_PERF.season = @NewSeason
--If you don’t need to assign to a new season, comment out the season part above in the set section.
OUTPUT DELETED.perf_no, DELETED.prod_season_no, INSERTED.prod_season_no, DELETED.season, INSERTED.season
INTO @ReplaceProdSeason

FROM T_PERF
       join T_INVENTORY on T_INVENTORY.inv_no = T_PERF.perf_no
where 
       --T_PERF.perf_no = @PerfNo
       T_PERF.perf_no in (select T_PERF.perf_no FROM T_PERF WHERE T_PERF.prod_season_no = @OldProdSeason)
       and T_INVENTORY.description = 'Hybrid Camp Admission'
--could be like instead of ='s

SELECT * FROM @ReplaceProdSeason
;
/* 
If ok, then highlight and execute:
COMMIT TRANSACTION A;

If not ok, then Rollback transaction highlight & execute:
ROLLBACK TRANSACTION A;
*/

What is nice about the script is that it will display the changes before you commit the transaction. In other words, you can quickly check for errors on your part and roll it back. Make sure you absolutely know which performance numbers are supposed to be moved and to what production season (and season).

You can use the Reschedule button the performances to open the rescheduling window, and you can select a different production season. (Unlike the name implies, you don't need to change the date or time of the performance if you don't want to.) 

Well, that's too easy of a way. lol.

Well that worked! lol

I just wish there was an easy way to do all of them all at once instead of using the reschedule button on every single performance. Season Maintenance is great for everything else, but rescheduling in mass isn't an option.

And here I am just happy that there is an application based solution to this.  I have been using my own custom solution for this for years.

Sounds a little like a be careful what you wish for, taking into consideration what could go wrong along with what could go right.  Like, if they make it, make sure it displays changes before you commit. 

Fair enough.  But I have also been using my own custom solutions to too many things at this point to look back.  I will train new staff members with the proper methods.  But I have become nearly untrainable at this point.  Much as I even teach the opposite to others.

I meant that for wishing for mass updates in out of the box Tessitura,  John.  Sorry I replied to the wrong link in the chain. I, too, am untrainable.