How To Exclude a column from being replicated to the target table
- This topic has 0 replies, 1 voice, and was last updated 8 months, 2 weeks ago by .
- You must be logged in to reply to this topic.
A source DB has several columns but one of the columns has sensitive data (NPI, Non-Public Information) that you don’t wish to replicate to the target DB. Or you may have determined a new requirement to be removing a column that has sensitive (NPI) data.
What is the correct procedure to exclude such columns from being replicated to the target side?
5. Run HVR Initialize for the Capture and Integrate location with “Scripts and Jobs” checked as well as “Table Enrollment”
6. If this table had previously existed in replication but this is a new requirement to exclude the column from the target, then you create the new action in Step 4 then perform an Online Refresh with Recreate table(s) option for the affected table(s). This will be necessary to get the data and layout back in sync with the column and data removed from the target.
© 2020 HVR
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.