Fandom

Scratchpad

Adding a column to a table in production

219,209pages on
this wiki
Add New Page
Discuss this page0 Share

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

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.

Also on Fandom

Random wikia