We have the central office and several stores around the country.
We need to let the stores work even when the Internet is down or poor, so I’m thinking to deploy the same datatabase in the office and in the stores.
I don’t know if sql server replication is suited for this, I read something about it but I am not familiar with it. I can’t figure out how, for example, two different products created with the same ID in two stores will be reconciliated. Not to mention the invoices using those products.
It seems more under control to perform some data update periodically.
Can anyone help me with some ideas, please?