Friday, March 9, 2012

Publishing Parts of a table

I'm new to SQL 2000, one of my customers requires two tables of my DB replicated on it's server, for auditing, I guess.
I'm thinking about using transactional Replication given that the changes are made often and the tables are going to increase fast in size. The problem is, in the same tables, I have information also from other customers that I don't want to replicate to
the one is asking me this. So, Is there any way to do this? I mean, apply a kind of Select to the tables before sending the transactions to the Subscriber server? so they only receive what concerns to them.
I don't know if my question is clear or not, sorry about that, and thanks so much for the help.
Manuel,
you can filter the rows in the publication properties. This is on the
"Filter Rows" tab. You should end up with a filter something like this:
SELECT <published_columns> FROM <<TABLE>> WHERE
<<TABLE>>.categoryid > 2
HTH,
Paul Ibison

No comments:

Post a Comment