Is there a way to replicate some data not all data in db by sql server replication?

Question

I want to replicate some of data that exists in my database. I want to replicate specified data. Is there a solution?

do mean replication of selective tables or selective columns within a table ? — , Feb 22 '10 at 07:00

score 4 · Accepted Answer · answered Feb 22 '10 at 18:04

USe Replication Row Filters:

Using static row filters, you can choose a subset of rows to be published. All Subscribers to a filtered publication receive the same subset of rows for the filtered table

alt text http://i.msdn.microsoft.com/ms151775.e4e1c995-fe81-4c05-b661-39087b323161(en-us,SQL.100).gif

Is there a way to replicate some data not all data in db by sql server replication?

1 Answers1

Linked