The custom solution we developed for our client enabled their sub-offices to access and update information while working in remote locations with intermittent internet access. Using SQL Data Replication data was synchronized to a data center. The data was then replicated to the sub offices using a custom developed windows application. An online application allowed administrators to generate reports, push modifications and edit submitted data.
- Data was synchronized from Head-office to a Data center.
- SQL replication managed the merging of data from the data center to the various sub-offices.
- A windows application allowed the sub-offices to view, edit and synchronize the data.
- The internet application enabled head-office to view and edit submitted data as well as push updates to their sub-offices.