Search code examples
sql-server-2008-r2filteringreplicationtransactional-replication

Filtering column data in SQL Server 2008 R2 Transactional Replication

Is it possible to filter the data content of columns published in standard transactional replication of a SQL Server 2008 R2 database?

If I filter the columns themselves, they vanish entirely in the subscriber tables. I want the columns to exist, but be empty regardless of whether there is data in that column on the publisher side.

Thanks much in advance.

Solution

  • Yes, this can be done by adding the columns using a post-snapshot script. Have a look at Execute Scripts Before and After the Snapshot Is Applied.