How to synchronize an offline database with an online one?
I have two identical databases, one of which is offline and the other is online.
In every field of a table I have a column called online with values 0 (did not send the data) or 1 (already sent the data).
Usually I check if there are any fields in my table with column online with value equal to 0, and if there is, I send the record to online bank and change the value to 1.
Works very well that way. The bigger question is if I have two people using the system.
How can I send data of the two customers to the online bank and have each of the customers receive the data that the other sent?
1 answers
Wave. If I understand correctly...I can say that using the database replication feature is the best alternative, I have already gone through a similar situation where parts of the data should be in several different locations, so that using the conventional architecture (Client/Server) would overload the network... All banks already support replica, PostgreSQL, Oracle, sql server.....Trying to do this on the basis of the code is a headache in the right..... It is also possible that your problem can be solved using the Sass architecture...(Use Web Api for example..Rest full) let the database work on this...designers have already given themselves to this work... rsrs Sorry I can't help you by posting code, but that's what I could infer from the context.
Hug.