I am working in small bank with 6 branches and a Headquarter. Each Branch is running a SQL server with 8 workstation connected to it over LAN. At each day end branches closes their work send their data to headquarter in an export file format. Where it is imported to Headquarter Sql Server database through an email.
Now bank wants to connect its branches directly over a private network to Headquarter. But the branches should not connect each other directly. Bank wants that branches connect each other through the central ( Headquarter ). and customer can make transactions across the branches. For example a customer of bank A in city A can draw its money through bank B in City B. Then in this case to avoid any mistake the customer record bank A in city A should be instantly available to the staff at Bank B in City B. the one anwer to this scenario is that the branches maintain a Central Database Server at Headquarter and connect it directly.
But banks do not want this answer. As central database server is unavailble or network link to central server at headquarter of a branch is down then the branches cannot work. The bank do not want to change its current scenario but only want to allow cross transactions among the branches online to facilitate the its customer. Kindly suggest the solution that how the sqL servers are placed and confiured to communicate in such a way. Hoping soonest soluion....