Saturday, February 25, 2012

Reolication Filters and linked tables

Hello
I have a table lets say Accounts with 2 fields Account_id and
account_name
and another table called AccountAddress with again 2 fields Account_Id
and Address_Id.
As you can imagine the Account_Id of table Accounts is linked with
Account_Id of table AccountAddress.
Now if a replicate my database and i put a filter on table accounts to
bring lets say accounts with account_name="test" ... shall i put a
filter to table AccountAddress too or this table will bring data for
those rows that exists in table account during synchronisation?
(I use merge replication in sql 2005 in order to replicate the
database on sqlce database)
Thanks a lot
Savvas
As long as there is a defined merge join filter the merge agent will take
into account the static filter.
Rgds,
Paul Ibison

No comments:

Post a Comment