Re: Real time replication over geographically divers sites

That depends on what the cost of latency is.

For something like this you should probably look at a citrix solution where
the UK and SA users both logon to the same database at the same time.

However, you can probably do this using replication if you relax the latency
requirements to a minute or more, and then use bi-directional transactional
replication, if and only if you can partition your data - possibly by using
dbcc checkident to create different ranges in the UK and SA.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"John Norton" <JNorton@xxxxxxxxxxxxxxxxx> wrote in message
news:a2f128be.0503310645.16813d3d@xxxxxxxxxxxxxxxxxxxxx
> 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: Huge Replication Scenario
    ... Replication will work, but the latencies can be lengthy (ie several ... SQL Server installations. ... To overcome latency issues we are planning to have about a dozen SQL ... What concerns us is our huge database, ...
    (microsoft.public.sqlserver.replication)
  • Re: Transactional Replication
    ... For very fast latency and automatic failover there is clustering, ... replication with queued updating subscribers, ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: How to keep SQL-DMZ and SQL-Internal in sync ?
    ... Let's say latency <= 1 hour. ... > SQL Server Replication is an option. ... > Mike Epprecht, Microsoft SQL Server MVP ... >> I mean in the past I used robocopy tools to help me keep folders in sync ...
    (microsoft.public.sqlserver.security)
  • Re: Major Latency problems
    ... replication monitor is because they are occasionally wrong. ... represent cumulative values since the last time the distribution agent ... Replication monitor latency is 1 ... you're asking me to alter a stock replication system table. ...
    (microsoft.public.sqlserver.replication)
  • Re: IS replication REALLY the way to go?
    ... Latency added depends on the ... delay in Syncronous mirroring. ... Hardware based replication is bound to ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)