Filtering column data in SQL Server 2008 R2 Transactional Replication

Question

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.

score 2 · Answer 1 · answered Dec 28 '13 at 06:57

2

Not out of the box, but you could hack the subscriber procedures to do that.

answered Dec 28 '13 at 06:57

SQLGuyChuck

192
7

score 1 · Accepted Answer · answered Dec 30 '13 at 01:13

1

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.

answered Dec 30 '13 at 01:13

Brandon Williams

3,695
16
19

I like Brandon's idea, publish without columns, then in post snapshot script, add them if they don't exist. – SQLGuyChuck Jan 01 '14 at 01:19

Filtering column data in SQL Server 2008 R2 Transactional Replication

2 Answers2