[dschenk]

Okay, thank you. I do appreciate the advice. I do in fact have an autoincrement primary key, and I think I understand what you are saying about the trouble I may run into with that just being the number by itself and so coupling it with a fixed value in either database. Great for adding new records, but please go back to what I said I want to be able to do. As I understand your answer there is no way I will be able to alter only particular fields in existing records of each of the versions of the databases and to have the changes preserved. Is that correct? I hope I am misunderstanding that since the whole thing will be of little value to me otherwise.

[dschenk]

What is PK? I think if a sync is what I understand that it is. target and source terms are a bit arbitrary here. I want changes to be made independently on my linux server copy and on my roaming laptop copy and then to be able to sync and save the most recent changes/entries in each and have that new merged version be replicated on both the server and the laptop. That's what I hope will happen. In fact, I always get the server copy, even when doing a two-way sync. What am I missing?

[dschenk]

I got this far and downloaded the beta. The old version and the beta give me the same result. Changes made to my target database locally are consistently overridden by the values in the source database, even though I am making those edits days after the source entries. New records added to the target database will be uploaded to the source, but target edits are not. My source is running on SME linux and is Version 12.22 Distribution 4.0.23. My source is on win2k and is mysql 4.1.8 NT. Is the source difference significant, or should I be looking for some other problem?

[Author]

Posts