Change to Production Season

you can do something to check out whether you can update the t_prod_season table.

1,copy LIVE database to TEST.

2,in management studio, right click impresario database

go to Tasks ,then go to Genarate Scripts, you can select tables only and save them into ONE file.  (there are 900 tables, it will take a while. it took me 40 minutes to get the script file.)

3,in the saved file, you can do search "prod_season_no"

exclude local table:

TW_PROD_SEARCH
t_imp_perf_data
T_PERF
T_PROD_SEASON

these four tables are only must to be updated.

in our setup also T_INVENTORY has prod_season_no match inv_no show the title of the performance.

local tables also need to be updated if they are in the list.

4,beware of triggers.

Finally, most likely, you can do the update.

 t_perf and t_prod_season you can have to mannually update them.

 t_imp_perf_data can be update by

[EIS_IMP_CHANGED_LOAD_NEW] with a full update parameter.

TW_PROD_SEARCH
it is link to web API. so it should be auto updated.

if you right click the table then "view dependcies"

there are four wp_ stored procedures linked.

So the work list is:

1,update t_prod_season

2,update  t_perf

3,update  T_INVENTORY (where prod_season_no=inv_no)

4,run EIS_IMP_CHANGED_LOAD_NEW with full update.( it should be in the SQL Job list)

5,update TW_PROD_SEARCH

6, update local tables if they are the list.

Do it in test first.

I am 90% sure all these will work.

:-):-):-)

Thanks Ben, this is awesome and exactly what I needed!!

Carli

Thanks Ben, this is awesome and exactly what I needed!!

Carli