SQL Express is becoming increasingly popular alternative to many small applications. It is freely available from Microsoft and is preferred choice for small businesses.
Recently, while working on some requirement, I was doing some research on achieving database synchronization in SQL Express. I thought it would be cool to have all those links at one place so someone can save some time.
Microsoft has also released Sync framework that you can download from here.
Synchronizing a server database scope (hosted in a SQL Server or SQL Server Express instance) with multiple client-side instances of SQL Server or SQL Express : Sample Code is here.
Here you will find 3 methods with the sample source code. If you don’t want to disable / enable referential integrity, while performing sync operation, then you should use Method 3. Again, they have all the sample code and you will need only some minor changes required.
A company named XSQL Software has some propritary API and an application that you can download and use for sync.
It gets tricky while doing Sync particularly when maintaining referential integrity, managing peer-to-peer and peer-to-client sync, etc. Similar to our team, you may perhaps find that writing custom sync from scratch is a better alternative to many of these options.