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.

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.