XML DB in a small local network

Question

I have an oflline local network  of 10-15 laptops and a WinForms application installed on all of them.

The application uses an XML file as a DB.  It is used for registration at conventions and meetings.

The same XML file is copied to each laptop before the registration and it contains the list of all people expected to arrive.

How can I synchronize between all the stations to see the real time state of arrivals at any point of time?

Thank You.

Answer 1

You need a single data source. Configure one of the laptops with a file share and have your application look there for it. This is still a problem because the file will be constantly locked by someone else.

I would suggest some type of lightweight database like SQL Server CE because that is simply a file (.sdf) and you do not need to install a database server. You just need the appropriate dlls referenced in your application.

http://blogs.msdn.com/b/sqlservercompact/archive/2011/01/12/microsoft-sql-server-compact-4-0-is-available-for-download.aspx

---

Bob - www.crowcoder.com