[tapsboy]

hi peter, thanks for your inputs…

let me tell u more about us first

i m not a DBAdmin…..just a php/mysql programmer

we are around 50 employees…….

almost half at our head office in ahmedabad……and

the other half……spread all across India…….

now we have build certain applications tat help this ppl from outside make direct entries on the internet…site…..

also…a lot of work is done at the head office…..

but internet speed being relatively slow..and it seems unlikely any gr8 change is gonna happen in near future about the speed……….

the ppl at HO can't work on the internet directly…

thus we maintain 2 databases…1 at HO and 1 on website…..

and synchronize them manually (means cut, copy, paste) as the needs comes……but with a lot of pains……and data loss due to human error……

ok now the issue…..

well i fully understand the fact that the computer or the software will not be able to make human decisions……

but what i want is basically……is that:

if there is a change on both the machines for the record with the same primary key…

it can give a prompt and an interface..

saying that this record has changed on both places…

it will show records as on both the servers aswell……..

and the user will be able to see the difference clearly.and then …..

change the respective records there itself……and update them on server…

currently with 2-way sync…

the source updates the target…..irrespective of the fact..whether there is change..in the target records or not……

this will work fine for newly inserted records…and

it might work well for deleted records…if auto-increment is used in PK

but in case of update…..

if SQLyog can detect…using timestamp…(a few seconds inaccuracy is OK )

tat change on a particular record has happend on both the machines…..

and it leaves the user to decide…wat to do…

it will be gr8…….

expecting ur reply soon……

Regards,

tapan

[tapsboy]

hey ritesh,

thanks for your prompt reply

newayz i believe ur from the company itself

firstly your product is certainly a good one..overall..

now SJA (i assume it is the core engine of SQLyog)

if it cannot take time into consideration then the overall sync objective is not achieved i guess..

wat it then actually does is very much user-dependant…..

i.e. depending on us specifying source and target…….

this scenario is highly dangerous…..

as new data last changed on the target would not change the source ……ideally this should happen in a 2-way sync….

and instead SJA change the new data on target with old data on source…

tats crazy at times…..

but anyway..if you have any other solutions..or ways to get around this problem……plz get back…

2-way sync becomes the main reason for us to purchase SQLyog if we do…….

thanks,

tapan

[Author]

Posts