Sql server database synchronisation

Question

I have 1 application , in which conditions are like i have to use local databases only for each PC....Now if some enrollment is done from 1 pc then that data should be store in local database and also it should be send to another PC...in short i want to synchronise all the data..

I need to clear 1 thing that "Centralize database is not possible..I cant use 1 database and connect to it from all PC.."So i need synchronization only...

I am using SQL SERVER Express Edition... and developing application in C# .NET

If have any doubt you can ask me i will describe more...

Answer 1

Since you're using SQL Server Express, replication is not an option. (Express versions can only subscribe in a replication scenario.) But you should take a look at the Sync Framework, formerly known as Sync Services for ADO.NET. It is an API for .NET that provides the kind of db sync capabilities which you may find helpful. From your description, the Collaboration Scenario seems the most applicable (peer-to-peer synchronization scenario.)