locked
SQL Server Merge Replication - Excluding A Column From Replication RRS feed

  • Question

  • Environment: One Head Office (HO) and 2 Stores (S1 and S2), SQL Server 2008 R2

    Goal:

    I need to exclude column Password (varchar (30)) from merge replication on table Users. The Password column needs to be local to where it is originally created (HO or S1 or S2). The POS application requires Password column in Users table to authenticate users. We need this column to be replicated as NULL on other locations.

    Things I tried:

    I excluded column Password from merge publication on table Users but when the snapshot agent works at S1 or S2 for the first time, it drops this column at subscribers. We need this column there.

    I tried to ADD COLUMN back after snapshot is applied using snapshot post snapshot script but it fails saying that objects can't be altered at subscriber.

    Any solution?

    Thanks

    Tuesday, April 12, 2016 2:50 PM

Answers

All replies