RE: Real time replication over geographically divers sites

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

What happens if the internet goes down?

You could run Merge replication every 5-10 minutes with no chance of data
clashes for tables that use identities.


Jim.


"John Norton" wrote:

> Hi,
>
> Myself and a colleague have been charged with making two SQL servers
> (SQL Server 2000 STD) replicate in real time, this is to allow a
> helpdesk system to be updated in either the UK or South Africa.
>
> Unfortunately as the helpdesk system we use is not by our own design
> we have to use the same reference range.
>
> Our fear is that a user would enter data in the UK taking the next
> available reference at the same time as one in SA which would result
> in clashing data!
>
> Considering that the latency between these sites can be as high as
> 500ms what do you think would be our best solution?
>
> Many thanks for any advice offered.
>
> John....
>
.

Relevant Pages

  • Re: Merge Replication!
    ... Merge replication does not provide real time replication, ... identity range management to avoid the pk conflicts. ... and select the automatic identity range management tab. ...
    (microsoft.public.sqlserver.replication)
  • Merge Replication!
    ... implement the merge replication (Kind of a Real time) between different ... databases sitting on separate servers. ... Prev by Date: ...
    (microsoft.public.sqlserver.replication)
  • Re: Real Time Data
    ... situations it is unlikely that you really mean real time. ... Replication is not normally the cuplrit unless you are using high ... Make sure all the reporting applications are using the nolock hint - ... SQL Server Reporting Services and SQL Server 2005, ...
    (microsoft.public.sqlserver.replication)
  • Re: real time reporting + OLTP dbs
    ... You might want to consider using read uncommitted query because replication ... > How does one implement real time reporting off of data from the OLTP ... Right now we run nightly extracts and load into OLAP DBs to ... > access to the live OLTP systems. ...
    (microsoft.public.sqlserver.server)
  • Re: Creating an Intranet and an Extranet WSS with replicated SQL DB
    ... I am a little perplexed as to why you think a replicated DB would better serve the client needs unless the Intranet and Extranet hardware is not in the same location and connected to the same internet connection, but that does not appear to be the case. ... Dealing with a replicated database concept, you will undoubtedly run into the "real time" issue where the client wants something done on one system to be reflected in real time in the other system. ... If you don't have to deal with real time replication of updates, you may have more of a window to work with but still... ...
    (microsoft.public.sharepoint.windowsservices)