Is there a standard practice for synchronizing SQL Server tables?
- by EngineeringAutomation
I've written an application that retrieves pricing and part options from a SQL database to generate a 3D Model of the product and create a sales proposal. My client likes it so much they want to be able to use it on laptops in the field now. The catch is, they won't have an internet connection.
I'm considering setting up a SQLite database as part of the standard installation. The SQLite database on each laptop will synchronize with the main database when the internet connection is re-established.
Are there best practices regarding synchronizing SQL tables like this? Are there any pitfalls I should consider? I'm open to all options.
Thank you.