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?

Answer 1

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

See also:

• How to: Define and Modify a Static Row Filter (SQL Server Management Studio)
• How to: Define and Modify a Parameterized Row Filter for a Merge Article (SQL Server Management Studio)