How to filter the row in merge replication.

Hi There,
I would like to filter the row in several tables in merge replication
for the subscribers. I would like to filter the row with the criteria
saying only trasfer the data for last week or latest last(7 days data)
to the subcriber and the second option is first 100 rows. If there is
any information in this please forward to me.
Thanks a lot.
Indra.
Indra,
there is a parameter on the merge agent that you might like to look
at: -MaxDownloadChanges.
However, I'd like to know a little more about your scenario. On the
publisher no doubt there is some data older than a week. Is this data
intended to exist on the subscriber? What about if some of this older data
is modified on the publisher, should the change be propagated? Please post
up a bit more info.
TIA,
PAul Ibison
|||You can use static row filtering, which is documented in Books Online.
thanks
gopal
|||Hi Paul,
I reply for this message long time back but its not apper here, replying
again.
Acutally we have one server working as publisher, distributer and
several subscriber (install MSDE, sql client utility) and having adp
front end for the applicaiton. since they donot need all the data, i
just wanted to send them for few table data of say last two week or 20
etc. actuall publisher may have data which have been modified in the
main office, which in not necessary to send it back to them, becasue we
are receiving all the job information form the field office and once we
received it we will process othe information here in main office and it
not necessary to replicate or propagated back to the subscriber.
As mention by Gopal, I try to check with static filter its giving me
porblem. I willtry again tomorrow and let you know how its work.
Thanks for help.
Indra.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||One thing to be very careful with is what you want the subscriber to have.
When you implement a filter, merge will literally enforce that filter across
your data. That means if your filter is for say the last 20 days and
someone inserts a row of data older than this, that piece of data will be
removed from the subscriber after it is sent to the publisher.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com