I'm developing a C # system with WinForms of Livestock Control for a farm, and will communicate with a scale to improve the weighing process.
Some of the features are (Invoice entry, vaccination, casualties, transfers, purchases, stock).
I have some doubts regarding the structure, because in the farms does not have internet. And the manager will be able to access the data through the office. So I do not know how to do it, because I would have a local system and a web system?
I figured I could have a separate module to do the weighing, using a local bank (SQL CE, SQLite), as I believe it is not worth installing a SQLServer database on the "pawn" machine, and then going synchronize in cloud with the management system, after getting connection to internet.
And functionality regarding purchases, downgrades, etc ... Would you stick with this offline module?
My thinking is correct, and which database should I use for each situation?