Help in Designing Architecture

Question

User-1800438376 posted

The architecture consists of

DataCenter:- Website and Sql data base will be hosted

Box Office :- connect to website and sell tickets online and if no connectivity work offline with the local database.

Outlet :-  connect to website and sell tickets online

The problem is how do i sync when the internet is not availiable and how do i manage the concurrent booking.

Answer 1

User-1366948256 posted

You need to create a job in sql server which will run and sync databases.

Answer 2

User-1800438376 posted

hi Jalpesh,

     Thank for giving light to my arch. The problem arises when the booking is done at outlet and that is not reflected on the local database because of no internet connectivity.

Answer 3

User-952121411 posted

This is the same thread you posted here:

http://forums.asp.net/t/1557298.aspx

...check out the Microsoft Sync Framework; it will provide functionality to solve your issues.