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

Databse Synchronisation

So why wouldn't querying both databases at the same time work (not the best solution, but if there are only two databases, and there isn't a huge load)? I'm guessing you have thought of this, but I don't see the issue with it (yet). — Jess
– Jess, Commented Apr 16, 2011 at 6:50

Paul Sasik · Accepted Answer · 2011-04-16 05:52:21Z

4

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

edited Apr 16, 2011 at 5:52

answered Apr 16, 2011 at 5:36

Paul Sasik

81.9k23 gold badges152 silver badges194 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jess · Accepted Answer · 2011-04-16 05:56:07Z

0

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

answered Apr 16, 2011 at 5:56

Jess

8,7306 gold badges51 silver badges68 bronze badges

1 Comment

Kishan Gajjar Over a year ago

Thanks...but i am looking some solution for c# .net....i am not a java person..so cant understand the java code ...

Collectives™ on Stack Overflow

Sql server database synchronisation

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related