Thread: staging database and consistency
08-28-14, 06:21 #1Registered User
- Join Date
- Aug 2014
staging database and consistency
I have a scenario for my application. The source for my application is in several external DBs. What I have in mind is to use staging database and perform the sync at the end of each day. But the problem is that both sides are in change during the day and they might be in different states from the their initial state. how can I solve my problem without major loss in applications' functionality ?
I have attached the scenario picture here.
Thanks in advance
Last edited by sialta; 08-28-14 at 09:48.
08-28-14, 11:45 #2Resident Curmudgeon
- Join Date
- Feb 2004
- In front of the computer
There are a number of solutions for inconsistently connected replication.
- One database can be designated "authoritative" and it always wins
- Changes can be time stamped, and most recent change wins
- Application specific rules can resolve conflicts
- Both values can be kept separately, let the user decide
-PatPIn theory, theory and practice are identical. In practice, theory and practice are unrelated.