SQL Server; storing data in offline mode.
Posted on 2016-08-17
I have a non-WEB based Windows app that our technicians use in the field on PC tablets. It saves entered data to an Access database. When the tech is done working for the day, there is a sync feature that syncs/sends the Access data to a SQL database in our home office. There are multiple issues with this syncing process that cause us grief. Duplicate data, loss of data, etc.
What would be nice is to have a WEB-Based app on the technician tablets, that can talk directly to the SQL server database. The problem is that due to location, the physical environment, etc., the tablets often cannot get a WIFI connection/signal.
What would really be nice: The technician can enter their data on the tablet and if there is no WIFI connection, the data is saved somehow - (cached, stored, ??? etc) without using a local Access database, using some SQL or other robust mechanism, until such time that there is a WIFI connection and then write the data to the home office SQL database.
Hope this make sense. Anyone have any ideas?