Replication methods on unreliable network???

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Everyone,

I'm inquiring in the possiblity of using the built-in components/tools
of Microsoft SQL Server 2000 or if necessary, 2005 for replication on
an unreliable network. I have a machine out in the middle of nowhere
that has a local MSDE installed and data from the field goes onto this
machine. In the office, I have a SQL Server 2000 setup and I would
like to synchronize data from the field with the data in the office.

The network connection can be really bad so we usually expect
downtimes. Is there any built-in component that can support
replication on this type of network? I've been looking at Microsoft
Message Queue and I'm wondering if I can incorporate this into it...
If need be, I can also upgrade to SQL Server 2005.

Any comments/suggestions would be much appreciated!

Thanks in advance,

Eric

.

Relevant Pages

  • RE: Reconciler Problem
    ... 2000 Windows CE Edition (SQL Server CE) Replication Synchronize: ... Microsoft SQL Server 2000 Windows CE Edition ... Delete the locate database on the device and then re-create ... NOT FOR REPLICATION Clause Causes SQL Server CE Replication to Fail ...
    (microsoft.public.sqlserver.replication)
  • Re: Message ConnectionOpen (PreLoginHandshake()).
    ... This is normally a problem with your network. ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... I have vendor application replication set up on Windows 2000 Advanced ...
    (microsoft.public.sqlserver.replication)
  • Re: High Availability
    ... The cluster uses heartbeat to detect whether a node is alive or not responding. ... You may want to research SQL Server Replication/ Log Shipping if you can have some latency. ... Typical Uses of Replication ... Introducing New Features in Microsoft SQL Server 2000 Transactional Replication ...
    (microsoft.public.sqlserver.clustering)
  • Re: Replication methods on unreliable network???
    ... Replication is designed for lossy networks. ... Looking for a SQL Server replication book? ... of Microsoft SQL Server 2000 or if necessary, ... an unreliable network. ...
    (microsoft.public.sqlserver.replication)
  • Which Replication Option???
    ... I am new to replication in SQL Server, ... I have a SQL Server on our network, ... and another on in our DMZ. ...
    (microsoft.public.sqlserver.replication)