I've come to notice that our Production Elements are a mess! With most shows being setup as brand new titles, rather than using existing titles, and productions.
I would like to clear it up by moving the productions, production seasons and performances into the correct places. This seems simple enough by correcting the values in SQL, but should I? Is there any built in utilities that can do this for me? Could it break anything (apart from my local ticket history tables...)?
Has anyone done this before and it caused problems?
Any help would be appreciated.
Thanks
Not an endorsement per se, but I have moved performances from one production season to another, and prod_seasons to different productions simply by changing the prod_season_no in t_perf and changing the prod_no in t_prod_season respectively. Haven't had any issues arise, although, as you point out, ticket history tables would be the first place I would check.