SQL Server 2005 Replication - fitlers

scargill

Hi all,

I don't think I can do what I want to do but I'll ask anyway.

I have a table, but I would only like to replicate rows to another server where particular criteria are met. They way I was going to do this was to add a filter on the article.

Something like....'where colA > 1000' (This is hugely simplified so I can explain it!)

The reason I need to do something like this is that the software on replicated database (website) can't be changed at the moment to filter particular records. Also, the data is sensitive.

The problem is that the values in ColA regularly change so the number of rows that satisfy the filter criteria can change.

Am I right in thinking that SQL server won't 'replicate' the new rows that suddenly satisfy the filter ?

Thanks

Using transactional replication. Snapshot replication is not suitable as it is a huge database feeding a public website.

scargill

think I found the answer - took a bit of googling.

join filters