Difference between revisions of "Migrating Schema Changes Between Systems"
From SDU
(New page: == Migrate from development to test/production environment == This is deeply described in Modification Guide, but it that routine you must run Web Screen Painter on the destination product...) |
|||
| Line 2: | Line 2: | ||
This is deeply described in Modification Guide, but it that routine you must run Web Screen Painter on the destination production server. Here is step by step manual how to do unattended replication: | This is deeply described in Modification Guide, but it that routine you must run Web Screen Painter on the destination production server. Here is step by step manual how to do unattended replication: | ||
| − | + | # On devel environment open Web Screen Painter and using Schema Designer make your required changes | |
| − | + | # Save all changes | |
| − | + | # Select File - Save and Publish in Schema Designer | |
| − | + | # Extract wspcol and wsptbl tables | |
pdm_extract wsptbl > wsptbl.txt | pdm_extract wsptbl > wsptbl.txt | ||
| − | pdm_extract -f "SELECT column_name,dbms_name,description,display_name,is_cluster,is_descending,is_indexed, is_local,is_not_null,is_order_by,is_required,is_skey,is_unique,is_write_new,is_wsp,last_mod_dt,on_ci_set,on_new_default, schema_name,status,string_len,table_name,type,xrel_table | + | pdm_extract -f "SELECT column_name,dbms_name,description,display_name,is_cluster,is_descending,is_indexed, is_local,is_not_null,is_order_by,is_required,is_skey,is_unique,is_write_new,is_wsp,last_mod_dt,on_ci_set,on_new_default, schema_name,status,string_len,table_name,type,xrel_table FROM wspcol" > wspcol.txt |
| − | FROM wspcol" > wspcol.txt | + | # Copy these files from source to destination environment ''(can be done in unattended patch)'' |
| − | + | ## [[$NX_ROOT]]/site/mods/majic/wsp.mods | |
| − | + | ## [[$NX_ROOT]]/site/mods/wsp.altercol | |
| − | + | ## [[$NX_ROOT]]/site/mods/wsp.altertbl | |
| − | + | ## [[$NX_ROOT]]/site/mods/wsp_index.sch | |
| − | + | ## [[$NX_ROOT]]/site/mods/wsp_schema.sch | |
| − | + | ## wsptbl.txt ''(extracts from previous step)'' | |
| − | + | ## wspcol.txt ''(extracts from previous step)'' | |
| − | + | # On the destination server run | |
| − | + | ||
pdm_load -if wsptbl.txt | pdm_load -if wsptbl.txt | ||
pdm_load -if wspcol.txt | pdm_load -if wspcol.txt | ||
| − | + | # Stop Service Desk | |
| − | + | # Run pdm_publish | |
| − | + | # Run Service Desk | |
| − | + | ||
| + | === Optional Steps === | ||
| + | If you want to save SCH and MOD changes in your own file with better name, follow these steps: | ||
| + | # Copy content of wsp.mods file to some *.mod in [[$NX_ROOT]]/site/mods/majic | ||
| + | # Copy content of wsp_schema.sch file to some *.sch in [[$NX_ROOT]]/site/mods | ||
| + | # Copy content of wsp_index.sch file to some *.sch in [[$NX_ROOT]]/site/mods | ||
| + | # Delete wsp.mods, wsp_index.sch and wsp_schema files | ||
Revision as of 14:04, 18 September 2008
Migrate from development to test/production environment
This is deeply described in Modification Guide, but it that routine you must run Web Screen Painter on the destination production server. Here is step by step manual how to do unattended replication:
- On devel environment open Web Screen Painter and using Schema Designer make your required changes
- Save all changes
- Select File - Save and Publish in Schema Designer
- Extract wspcol and wsptbl tables
pdm_extract wsptbl > wsptbl.txt pdm_extract -f "SELECT column_name,dbms_name,description,display_name,is_cluster,is_descending,is_indexed, is_local,is_not_null,is_order_by,is_required,is_skey,is_unique,is_write_new,is_wsp,last_mod_dt,on_ci_set,on_new_default, schema_name,status,string_len,table_name,type,xrel_table FROM wspcol" > wspcol.txt
- Copy these files from source to destination environment (can be done in unattended patch)
- On the destination server run
pdm_load -if wsptbl.txt pdm_load -if wspcol.txt
- Stop Service Desk
- Run pdm_publish
- Run Service Desk
Optional Steps
If you want to save SCH and MOD changes in your own file with better name, follow these steps:
