Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Remote » SQL Remote systems » Typical SQL Remote setups


Server-to-server database replication among offices

In this example, SQL Remote provides two-way replication between the database servers at the sales offices or outlets, and the central company office. The only work required at the sales offices is the initial setup and ongoing maintenance of the server.

Layers can be added to SQL Remote hierarchies: for example, each sales office server could act as a consolidated database, supporting remote subscribers who work from that office.

A hierarchical database environment, with many remote laptop computers and two consolidated databases.

SQL Remote can be configured to allow each office to receive its own set of data. Tables such as staff records can be kept private in the same database as the replicated data.