Offline data synchronisation

Does anyone know of a solution for OFFLINE Data Synchronisation for .Net
applications sitting on top of MS SQL databases in an asynchronous, limited
and expensive bandwidth (<=9600bps) configuration (i.e. synchronisation data
need to be exchanged in the form of files or any other asynchronous method.
Connections of up to 9600bps make establishing sql connection through tcp/ip
very costly)
I need to create about 50 DB's and keep certain data in synch with a central
DB. I thus need to (ideally) be able to “target” information to particular DB
when synchronising from the central DB out to the 50 instances. Data from
these databases should also be synchronised with my central DB. Conflict
resolution is another issue that should be dealt with.
I would consider anything which can deliver a flexible, operable and
reliable solution (off the shelf product, generic or specific, best practise,
design, sample, etc).
I have briefly looked into SQL Server 2005 Replication Services
(publication,subscription) and although it seems like a perfect solution I
could not figure out if it would work in the offline, asynchronous mode (i.e.
through file exchange and not direct sql connection).
Please point me in the right direction!
Thanks in advance…
Lastis,
replication won't work if you have no SQL connection. A few requests have
been posted for a file-based solution, so you might want to add it to the
SQL wish list.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||We might be able to help you here. Contact me offlist and I can tell you
more about our synchronization technology.
Andrew
"Lastis" <Lastis@.discussions.microsoft.com> wrote in message
news:3EF48BAF-4B96-4144-8C21-49E78EC81A20@.microsoft.com...
> Does anyone know of a solution for OFFLINE Data Synchronisation for .Net
> applications sitting on top of MS SQL databases in an asynchronous,
> limited
> and expensive bandwidth (<=9600bps) configuration (i.e. synchronisation
> data
> need to be exchanged in the form of files or any other asynchronous
> method.
> Connections of up to 9600bps make establishing sql connection through
> tcp/ip
> very costly)
> I need to create about 50 DB's and keep certain data in synch with a
> central
> DB. I thus need to (ideally) be able to "target" information to particular
> DB
> when synchronising from the central DB out to the 50 instances. Data from
> these databases should also be synchronised with my central DB. Conflict
> resolution is another issue that should be dealt with.
> I would consider anything which can deliver a flexible, operable and
> reliable solution (off the shelf product, generic or specific, best
> practise,
> design, sample, etc).
> I have briefly looked into SQL Server 2005 Replication Services
> (publication,subscription) and although it seems like a perfect solution I
> could not figure out if it would work in the offline, asynchronous mode
> (i.e.
> through file exchange and not direct sql connection).
> Please point me in the right direction!
> Thanks in advance.
>
>
|||How can I contact you? I tried using the email in your profile but it did
not work.
|||Remove the nospam part from my email address. Sorry, I need to change that.
"Lastis" <Lastis@.discussions.microsoft.com> wrote in message
news:64EED715-CEB0-4828-BA2E-8C8E95F74762@.microsoft.com...
> How can I contact you? I tried using the email in your profile but it did
> not work.