Fandom

Scratchpad

Adding a column to a table in production

215,994pages on
this wiki
Add New Page
Discuss this page0 Share

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.

Adding a column to a table in production:

  • add the column to the primary OLTP server using the ’alter table’ command
  • add the column to the replication definition using the ’alter replication definition’ command
  • add column to all replicated data servers (tip: use the rs_helprep command to determine all replicate servers.) The table changed will have already been applied to the warm standby and MSA servers
  • recreate the view and grants for the table in common_db for each server, primary and replicate
  • if the column added required a trigger change, load the updated trigger(s) in the primary OLTP server
  • if needed, make sure that any needed rows have been added to column_value
  • if the table that the column was added to has any columns that contain registration number or external party id’s, reload the following stored procedures in primay OLTP server: c_alias_racing_people, c_merge_racing_people, c_peoplecleanup_merge, crud_horse_merge, crud_people_merge, u_merge_people, u_merge_race

Also on Fandom

Random wikia