What kind of storage with two-way replication for multi site C# application?
- by twk
Hi
I have a web-based system written using asp.net backed by mssql. A synchronized replica of this system is to be run on mobile locations and must be available regardless of the state of the connection to the main system (few hours long interruptions happens).
For now I am using a copy of the main web application and a copy of the mssql server with merge replication to the main system. This works unreliably, and setting the replication is a pain.
The amount of data the system contains is not huge, so I can migrate to different storage type.
For the new version of this system I would like to implement a new replication system. I am considering migration to db4o for storage with it's replication support. I am thinking about other possible solutions like couchdb which had native replication support.
I would like to stay with C#.
Could you recommend a way to go for such a distributed environment?
PS. Master-Slave replication is not an option: any side must be allowed to add/update data.