all groups > sql server replication > may 2007 >
You're in the

sql server replication

group:

unidirection replication


unidirection replication Shawn Mason
5/7/2007 10:46:23 PM
sql server replication:
I have a client requesting to one-way replication and they don't want to
start with the same data. They simply want to pick a day and start moving
all new entries from one to the other. Is there an easy way to do this?
the subscriber needs to be updated within minutes of the Publisher.

thanks,

Shawn

RE: unidirection replication Paul Ibison
5/8/2007 1:21:01 AM
When you say "pick a day" do you mean that this is the filter they'll use?
You might consider using merge replication with dynamic filters. Merge can
easily be configured to be unidirectional. This article should help:
http://www.replicationanswers.com/MergeChangesArticle1.asp
Cheers,
Paul Ibison

AddThis Social Bookmark Button