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
Saturday, February 25, 2012
Reolication Filters and linked tables
Labels:
account_id,
accountaddress,
andaccount_nameand,
database,
fields,
filters,
helloi,
linked,
microsoft,
mysql,
oracle,
reolication,
server,
sql,
table,
tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment