Introduction
How to exclude a column from being replicated from the source to the target table?
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?
Steps
-
Open Select Table Explorer, selecting the Source to connect. Select all tables you want to be replicated to the target including the tables that have sensitive (NPI) data.
-
Add Action Capture on the source location group.
-
Add Action Integrate on the target location group.
-
Add the Action Column Properties, selecting the table & the target location group. Enter the column in the /Names and click /Absent.
-
Run HVR Initialize for the Capture and Integrate location with Scripts and Jobs checked as well as Table Enrollment.
-
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.