Re: Subscriber scheduling

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hilary,

Thanks for your help, I really appreciated it!

Ben

"Hilary Cotter" wrote:

Yes, it does, pull is used when your subscriber is frequently disconnected,
over the internet, or you have lots of subscribers. Otherwise push is
probably best.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Ben" <Ben@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1999D8BC-E28E-45D6-9D1D-6760064F0652@xxxxxxxxxxxxxxxx
Hi Hilary,

Does the push subscription work in the same way as a pull (in terms of
updating both the subscriber and publisher)?

Thanks for your help!

Ben

"Hilary Cotter" wrote:

Either do a push subscription or use an active X control, .Net
application
using ado.net, Windows Synchronization Manager and schedule it using task
scheduler.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Ben" <Ben@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0831B5FD-8E8A-41B1-9EF8-FF79F17EB935@xxxxxxxxxxxxxxxx
Hi,

I have set up SQL Server 2005 Express as a subscriber. In the setup
process
I was not able to schedule the time interval for merge replication. How
can I
accomplish this?

Thanks

Ben






.

Relevant Pages

  • Re: non-updateable merge subscription
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... row from the publisher and send it to the subscriber. ...
    (microsoft.public.sqlserver.replication)
  • Re: msreplication_monitordata
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... "Hilary Cotter" wrote: ... This seems to only have non null values for the merge agent and then I ...
    (microsoft.public.sqlserver.replication)
  • Re: Peer-to-peer conflict resolution
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.replication)
  • Re: ReIndexing while using replication Important
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... "Hilary Cotter" wrote: ... Does the reindexing naturally replicate to the subscribers? ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_addarticle without re-creating entire new snapshot
    ... "Hilary Cotter" wrote: ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Use Paul ...
    (microsoft.public.sqlserver.replication)