Roll your own xtranet msde replication - Whats really required?

Greetings from Austin.
I have a number of remote msde's which need to replicate rows to a master
sql server instance located behind a static ip accessible through a
webmethod.
the remote msde's are non static ips and can only make requests. A Windows
service runs on each of the remote machines where changed rows are gathered
from the database within msde, the selects are bagged into various xml
stuctures and the call is made to the webmethod. Web method has 2 params
calltype (an int) and payload (a string). These type requests are made on a
clock by the windows service. Similarly requests are made using a different
call type where updates from the sql server trickle down in a structure and
are assimilated by the remote windows service, into the msde.database. My
question for the groups is Is there a better way to accomplish (essentially)
replication between a sql server and her flock of msdes? Has anyone done
similar extranet replication in a different way?
Best from Austin.

Rich Wood
MCSD
.

Relevant Pages

  • RE: Roll your own xtranet msde replication - Whats really required
    ... sql server functionality had been overlooked ... >> Your concern seems to be maximizing the speed of the update replication ... >> it help to split this into steps such that a client posts that it has data, ... >>> I have a number of remote msde's which need to replicate rows to a master ...
    (microsoft.public.sqlserver.msde)
  • Re: Advice Needed: Asynchronous Replication/Mirroring to central offic
    ... Looking for a SQL Server replication book? ... field offices return data to the central office so some of this "advanced" ... geographically-dispersed remote locations. ...
    (microsoft.public.sqlserver.replication)
  • Re: Transactional Replication problem Just Help.........................
    ... drop all publications, disable replication on the publisher, configure ... publisher to use the remote distributor, ... I have Push Transactional replication on SQl Server ...
    (microsoft.public.sqlserver.replication)
  • Re: Error after Windows Update
    ... what is the db compatibility mode on the subscriber in the subscription ... Looking for a SQL Server replication book? ... > "Unable to find the remote agent on the remote server. ...
    (microsoft.public.sqlserver.replication)
  • Re: TS vs VPN
    ... Using TS, w/o VPN ... The remote client connects to your local TS via Remote Desktop. ... "Foo" accesses the SQL server, which is nearby in a protected part of the network. ...
    (microsoft.public.windows.terminal_services)
Loading