Re: Use Replication or Not

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 10:16:03 -0700

In theory this is possible using DTS but could end up
being extremely complicated, as essentially you are
recreating merge replication. Complications arising from
this scenario are:

Deletes can't be flagged, so they'd have to go into an
audit table.

Updates could conflict with other updates.

Someone could update a record on the publisher while a
subscriber deletes the same record - another type of
conflict.

Once this lot is sorted out, you'd have to translate the
change accepted into your custom table and apply it into
the real table, assuming this scenario applies to modified
schemas as before.

Regards,
Paul Ibison

Relevant Pages

  • Re: Under what conditions does ActiveSync DELETE a file on the Pocket PC?
    ... Thats a very interesting scenario you are pointing out. ... synchronization settings, Deletes always Win. ... rule is only applied when a conflict occurs. ... In my ActiveSync Options, "Replace file on Desktop" is selected. ...
    (microsoft.public.pocketpc.activesync)
  • [git pull] Input updates for 2.6.26-rc6
    ... Please pull from: ... to receive updates for the input subsystem. ... conflict in drivers/usb/core/quirks.c, I hope this is OK because I don't ...
    (Linux-Kernel)
  • RE: RE: SUPER SPOOF DELUXE Re: [Full-Disclosure] Microsoft and Security
    ... you would click on a link from a site you are surfing that advises you to ... install the latest updates by visiting windowsupdate. ... > What an utterly pathetic scenario you present. ...
    (Full-Disclosure)
  • Re: Same row being updated and deleted
    ... What is the action in the profiler I could use to see all the updates I have ... >> How can I study the conflict more detail? ... >>> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: FYI:Stealth Windows update prevents XP repair
    ... See http://support.microsoft.com/kb/916259/en-us for your reference. ... The "reference" you posted involves a scenario where Windows will not scan ... for updates, throws 0x800700B6 error code in the log and is related to an ... Comically the post you replied to right before this one "Updates fail after ...
    (microsoft.public.windowsupdate)