Chapter 11 Setting Up a Mobile Intranet

SQL Remote replication technology

SQL Remote is an established message-based database replication technology. When combined with a database-hosted Web site it, enables your intranet applications and documents to be deployed on laptop computers.

SQL Remote is a transaction-based replication technology that provides:

Replication between a central consolidated database server and hundreds or even thousands of occasionally-connected remote databases.
A loose concurrency among all components of the dispersed database, and transactional integrity of your database.
Updates to occur via e-mail or file sharing.
A publish-and-subscribe model that allows your users to receive only the data they need.
The ability to place a full transaction-processing relational database on a notebook computer.
Replication of updates that occur at either consolidated or remote databases.
Centralized task via Sybase Central.

For complete information about SQL Remote, see the Data Replication with SQL Remote manual.

Web site replication

The components of a PowerDynamo Web site are HTML templates, other embedded objects (images, sound, video, and so on), and the data that adds content to the HTML templates.

Because these objects are all stored in a relational database, such as Adaptive Server Enterprise or Adaptive Server Anywhere, they can be replicated using SQL Remote. The databases against which the queries run can also be replicated, so that all the relevant portions of the Web site, including its dynamic content, can be replicated to mobile users.

As SQL Remote allows bidirectional replication, changes can be made to the data from a Web client and can be replicated back to the consolidated server.

You can manage replication of both the Web site and of the data using Sybase Central.