I am planning a new software. This software will have a central database, SQL. However, I want each terminal that this software is installed on to have a backup plan, in case the database server is disconnected for whatever reason. What is the best way to go about this? Should we just create a local file? We want a certain table to be always available to the terminal in case the sql server is disconnected. Also, how do we update this file when new items are inserted into the database? send over TCP/IP or retrieve by software on terminal? The issue with retrieve, let's assume we have 100 terminals, it would be a hassle to do each on individually.
Thanks in advance.