|
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:
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.
SQL Remote uses the transaction log for replication. As a result, only changed data is replicated during an update, ensuring proper transaction atomicity throughout the replication system and maintaining consistency among the databases involved in the replication.
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.
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.
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.