A Newbie here so be gentle!
I am helping a charity which has a number of shops. I have made a SQL EXpress based billing system that is working quite well.
What is required is - everyday for the sales data from each shop to be sent to a central cloud database so that various analysis can be run on the aggregated data.
Such a system is needed because the Internet is unreliable and not available 24/7- so a cloud only option is not practical.
There are half a dozen tables.
All the local databses are identical in structure.
One solution I thought of is to have a Temp Table for each Table and put all new transactions in the Temp Table as well as the normal Table and then find a way of pushing the temp Table to cloud to append the data.
I am using VBA and Excel to connect to the local MS SQL Express.
Any and all wisdom appreciated.