MSDE Replication Scenario

Greetings to fellow fleetfingers:

> May I ask for your opinion on a msde replication scenario?
>
> Here are the parameters of the scenario:
>
> 1. There are a number of standalone vb.net
> applications (named appx) living on different
> computers each uses an msde. Each is capable
> of accessing the internet. None are on static
> IP.
>
> 2. There is a threaded piece of appx which culls
> changed records from its msde.database.table(s),
> makes the returned rows into an xml structure and makes
> a web service call to a static ip. The web service
> sees the request type (a web method parameter)
> and the payload (a web method parameter) and updates records
> in a sqlserver located on its internal.
>
> What would be accomplished is (essentially) replication
> from the sql server instance to each of the msde instances
> (like we would if the sql server and each msde were on the same
> network. ) however this would be across the internet.
> Each msde publishes its essential elements and subscribes
> to changes that are made by the mother sql server.
>
> Is there a product that you know of that will accomplish this type
> of data transfer across the internet. Am I missing some essential
> features that already exist in msde?

Any one out there already walked this walk?
Any suggestions?

Fleetfingers

Web Synchronization sounds like what you are looking for. Take a look at the books on line topic "Web Synchronization for Merge Replication".

I'd love to hear back on how it goes.

Philip