**Situation:**
Hi, I'm coding using Lightswitch (C#) and am thinking of deploying to multiple sites the same application and database. 

The databases need to be synchronized/replicated to each other so each would have a merged database. However connectivity between the sites is not going to be 100%, so the synchronization/replication would be done whenever the connection is possible.

**Question:**

Would it be possible to accomplish this through SQL Server Express? If not, what would be the best way to accomplish this by code? Thanks!