CODEWITHSUNDEEP
c#sqlsql-server-2008synchronizationdata-synchronization
Kishan Gajjar
Kishan Gajjar

Reputation: 1138

Sql server database synchronisation

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...

Databse Synchronisation

Upvotes: 3

Views: 1649

Answers (2)

Jess
Jess

Reputation: 8700

Just a thought, if you really want data redundancy, looking at something like cassandra might be a better alternative.

Upvotes: 0

Paul Sasik
Paul Sasik

Reputation: 81517

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.)

Upvotes: 4

Related Questions