Just wanted to see if anyone has experience at all with this but we have an environment that has devices and a SQL backend. Also a Web UI where information can be entered and then information should be synced to the devices.

I know it is vague but just wanted to see if anyone had any suggestions for how to approach the sync process in this scenario. Obviously verify table data and that it is coming across correctly and also performance by overloading the system and verifying all devices are sending and receiving the correct information in an adequate amount of time.

Any suggestions are greatly appreciated.