How to design application for multi-branches POS?

Question

My new project is POS application that connect to database using ADSL connection (512 kbps). In each branch has own database that will enable when ADSL connection has problem.

From customer requirement, this application must be WindowsForm, so I want to know, how to design this application to make it performance is good as possible? (Customer need this application can transfer data as fast as possible)

Are there any book about this topic out there?

Answer 1

You could use a partitioned database and replicate the changes to the main office.

The WindowsForms application at each branch office would work against a local database. The database at each branch office would only include the data require by that office.

You could use the built in replication technology if you have it or the MS Sync framework (I am assuming that it is a MS technology app)