I'm working on hospital project that will run the hospital over offline lan network, i created server pc and other pc's have no sql server or databases, just connect to the server directly, the system depends on sql dependancy to monitor the data changes by all pc's to get last updates from the server, but their are some problems in this way, sometimes booking updates delay
What I have tried:
i heared that there an another way like creating a sql database on each client pc and sync with the server, anyway i want to know what is the best way solution in this situation?