SQL Remote systems

SQL Remote is a message-based technology designed for the two-way replication of database transactions between a consolidated database and large numbers of remote databases. Administration and resource requirements at the remote sites are minimal, making SQL Remote well suited to mobile devices.

SQL Remote provides the following functionality:

  • Multiple subscriber support   SQL Remote allows occasionally connected users to replicate data between a SQL Anywhere consolidated database and a large number of remote SQL Anywhere databases, typically including many mobile databases.

  • Transaction log-based replication   SQL Remote uses the transaction log for replication. As a result, only changed data is replicated during an update. It ensures proper transaction atomicity throughout the replication system and maintains consistency among the databases involved in the replication.

  • Central administration   SQL Remote is centrally administered at the consolidated database. A company can have a large mobile workforce with many unique databases without maintaining each remote database individually. In addition, SQL Remote operation is invisible to the end user.

  • Economical memory use   To run efficiently, SQL Remote uses memory economically. This allows you to use SQL Remote on existing remote computers and devices without having to invest in new hardware. Replication is possible to and from remote computers and devices with limited space; only relevant data is replicated from the consolidated database to the remote databases.

  • Multi-platform support   SQL Remote is supported on several operating systems and message links. SQL Anywhere databases can be copied from one file or operating system to another

 See also

SQL Remote components
Typical SQL Remote setups
SQL Remote replication process