Skip to main content
Software Engineering

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

2
  • How to handle the primary key differences among the db Commented Apr 20, 2020 at 7:37
  • syncing databases like this is a really difficult problem, unless you can limit how the data can be changed. A simple approach is to treat the local database only as a cache, and never modify it directly. A more general approach is to record change events instead of the changed results (event sourcing). You can then merge databases by replaying their event streams. But there can still be conflicts. Depending on the data, it may be necessary for a user to manually perform the merge. Commented Apr 20, 2020 at 9:18