Two Ways Data Synchronization, Delete Problem

[elitedivision]

Hi 🙂

i have a little problem using the Agent. I have an application splitted on 2: one “living” on the Web and another living on a pc in my office. They use two DBs (one is copy of the other): the source is on my pc and the target is on the web. I need to keep up to date both DBs with data that could be written on the web and on the client both: it works well but not when i delete one row.

As i delete a row on source db and i launch two ways sync instead to delete the row on the target db i notice it INSERTS the missing row on my source… and this is not i want.

Is it possible to delete a row from source to target db in a two ways sinc… if yes how i can get this result?

thank you for every help / advice 🙂

p.s. sorry for my english 😛 (i hope to be “understandable”)

—

Grammatico Giuseppe

http://www.elitedivision.it

[peterlaursen]

Why don't you use a one way sync for this? Two way sync won't delete.  

Though not brand new anymore, this article:

http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

.. will give you an idea of how the SYNC JOB is handled internally.

[elitedivision]

peterlaursen wrote on May 31 2007, 11:10 AM:

Why don't you use a one way sync for this? Two way sync won't delete.

because sometimes datas are updated before on target db, and other times on local db. It depends from the case and it's for this I need a two way sync: to keep trace of every modify it could occur on the 2 different DBs, target and source. I have only one rule: data can be deleted only on local db (the source) and never on the target, but like i said before i m not able to transfer this modify on the target DB…

So isn't there possibility to send a delete command on a 2 ways sync? no solution (using 1 way sync not solve my needings unfortunaly)? 🙁 sigh

[peterlaursen]

there is no way for SJA to handle this at the moment.

[elitedivision]

peterlaursen wrote on May 31 2007, 03:32 PM:

there is no way for SJA to handle this at the moment.

:huh: doh, i'll try to think about other methods 🙂

thanks anyway for you fast answers

[peterlaursen]

let me explain further:

When SJA reads the databases it cannot know wheter a row was inserted on on host or deleted at the other.  SJA does not know the 'history of operations'.  It only has data itslef.  It even cananot acces server logs (would demand acces to the file system and the API does snot provide that).  It does not read your mind either!

But still it would be possible I think to add options like 'never delete' and 'never insert' for either of the hosts.  So we will keep that in mind for future enhancements!

[Author]

Posts