SQL Remote Sybase SQL Remote uses message-based synchronization to update databases. This enables a company to have a large mobile workforce with many unique databases without having to individually maintain each remote database. In addition, SQL Remote operates invisibly to the end user. In order to run efficiently, SQL Remote uses memory economically. This allows companies to use SQL Remote on existing remote computers without having to invest heavily in new hardware.
All data is arranged in publications at the consolidated database site.
The database administrator at the consolidated site then subscribes remote users to the publications they require to do business. If the same section, or row, of data is updated at more than one site, a conflict can arise. SQL Remote uses conflict triggers to resolve this and to ensure that data is kept consistent throughout the company. The Message Agent sends these changes using a messaging system. The Message Agent at the remote site accepts the messages sent from the consolidated database and applies the transactions to the remote database.