Groups | Blog | Home
all groups > sql server replication > february 2006 >

sql server replication : Offline data synchronisation



Paul Ibison
2/20/2006 12:00:00 AM
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)

Lastis
2/20/2006 3:09:26 AM
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
2/20/2006 9:40:27 AM

How can I contact you? I tried using the email in your profile but it did
Andrew Grillage
2/20/2006 6:23:38 PM
We might be able to help you here. Contact me offlist and I can tell you
more about our synchronization technology.

Andrew


[quoted text, click to view]

Andrew Grillage
2/20/2006 6:58:53 PM
Remove the nospam part from my email address. Sorry, I need to change that.

[quoted text, click to view]

AddThis Social Bookmark Button