sql-server - 有没有办法通过 sql server 复制复制一些数据而不是数据库中的所有数据？

Question

我想复制一些存在于我的数据库中的数据。我想复制指定的数据。有解决办法吗？

Answer 1

使用复制 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

另见:

• 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)