5
I’m developing a C# system with Winforms from Livestock Control to a farm, and will communicate with a scale to improve the weighing process.
Some of the features are (Bill entry, vaccination, casualties, transfers, purchases, stock).
I have some doubts about the structure, because the farms do not have internet. And the manager will be able to access the data through the office. So I don’t know how to do, because I would have a local system and a web system?
I imagined that I could have a separate module to do the weighing, using a local bank (SQL CE, Sqlite), because I believe that it is not worth installing a Sqlserver bank on the "pawn" machine, and that then would sync in cloud with the management system, after getting internet connection.
And the features related to purchases, low, etc. Would be together with this module offline?
My thinking is correct, and which database I should use for each situation?
And how will you pass the farm data to the office?
– Maniero
@bigown Initially I thought of exporting the data to csv and loading into the office machine.
– Ricardo Farias
it would not be possible to place satellite internet?
– durtto
As you already communicate with the scale, I believe you know a minimum about serial communications and the like, so I suggest you a solution taken by the company I worked in, which is to use telemetry controllers via GPRS. such equipment can be found in companies like http://www.abstelemetria.com/ , it is worth taking a look at!
– Marciano.Andrade