Is there a standard SQL Server table synchronization practice?

Question

I wrote an application that extracts pricing and detail parameters from an SQL database to create a 3D model of a product and create a sales proposal. My client really likes the fact that they want to use it on laptops in the field now. The trick is they will not have an internet connection.

I am considering creating an SQLite database as part of a standard installation. The SQLite database on each laptop will be synchronized with the main database when restoring the Internet connection.

Are there any better SQL table synchronization methods like this? Are there any pitfalls that I should consider? I am open to all options.

Thanks.

Answer 1

See Introduction to Sync Framework Database Sync

Take a look at the Getting Started sample : Client and Server Synchronization , which is a simple example of offline synchronization between a central SQL Server database and SQL Server Compact Edition on clients. You probably end up using SQL Server CE for this instead of SQLite, but they are comparable.

Answer 2

I'm not sure how complicated your application is or how many laptops it will be installed, but it is like replicating data, which you can also look at your application’s deployment strategy.

Have you explored the deployment of ClickOnce for this application? This is a great addition to the Sync Framework and will allow you to synchronize your application updates with the data.