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

SQL Anywhere 12.0.0 (Français) » SQL Remote » Introducing SQL Remote » 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.