I'm wondering if anyone has any experience with changing the production that's associated with a production season. I know how to do it in SQL, but I'm trying to figure out if there are any negative ramifications that I should worry about.
For context: when we first went live two years ago, we built every single show with its own title, production, and production season. But this has left us with an unwieldy amount of titles and productions. So now we're going to make larger umbrella titles and productions for the individual shows to live underneath, essentially. I want to go back and change our past few years' worth of shows to fit this model, and delete over a hundred superfluous titles and productions. I did all of this in test and it worked wonderfully on the surface, but I'm worried I broke something I can't see.
Any thoughts? Specifically, I'm worried about messing up old ticket data, reports, T-Stats... anything that might still try to pull off a production or title ID that no longer exists.
My first thought would be to review any content (TX_INV_CONTENT) or keywords (TX_INV_TKW) associated with the titles and productions you intend to delete, since that information is intended to be inherited by the associated production elements.
Moving Productions between Titles or Prod Seasons between Productions shouldn't break anything as long as you update your Ticket History table — in the standard tables the production elements are hardcoded on each row.