Data Replication with SQL Remote
   PART 1. Introduction to SQL Remote
     CHAPTER 1. Welcome to SQL Remote       

About SQL Remote

SQL Remote is a data-replication technology designed for two-way replication between a consolidated data server and large numbers of remote databases, typically including many mobile databases.

SQL Remote replication is message based, and requires no direct server-to-server connection. An occasional dial-up or e-mail link is sufficient.

Administration and resource requirements at the remote sites are minimal, and a typical time lag between the consolidated and remote databases is on the order of hours or days.

Sybase SQL Remote technology is provided in two forms:

• SQL Remote for Adaptive Server Anywhere     Enables replication between a consolidated Adaptive Server Anywhere database and a large number of remote databases.

• SQL Remote for Adaptive Server Enterprise     Enables replication between a consolidated Adaptive Server Enterprise database and a large number of remote databases.

  Adaptive Server Enterprise     Sybase Adaptive Server Enterprise was previously known as Sybase SQL Server.

This book describes both of these technologies.

In a SQL Remote installation, you must have properly licensed SQL Remote software at each participating database.

     For a detailed introduction to SQL Remote concepts and features, see SQL Remote Replication Concepts.

  Supported platforms and environments

Supported Database Management Systems 

SQL Remote supports both Sybase Adaptive Server Enterprise and Sybase Adaptive Server Anywhere database management systems.

Not all operating systems and message systems are supported for both these DBMS's.

Supported message systems 

SQL Remote exchanges data among databases using an underlying message system. SQL Remote supports the following message systems:

• File sharing     A simple system requiring no extra software.

• FTP     Internet file transfer protocol.

• SMTP/POP     Internet e-mail protocol.

• MAPI     Microsoft Messaging Application Programming Interface, used in Microsoft products and in cc:Mail release 8 and later.

• VIM     Vendor Independent Messaging, used in Lotus Notes and in some versions of Lotus cc:Mail.

Not all systems are supported on all operating systems.

Supported operating systems 

SQL Remote for Adaptive Server Enterprise is available for the following operating systems:

• Windows NT     All message protocols.

• Sun Microsystems Solaris/Sparc     File sharing only.

• Hewlett-Packard HP-UX     File sharing only.

• Silicon Graphics IRIX     File sharing only.

  SQL Remote Open Server on IRIX     A bug in IRIX that was fixed in the IRIX 10.0.3 release EBF 7658 is required for the SQL Remote Open Server. ssqueue systems involving SGI/IRIX should make sure this patch is installed.

• IBM AIX     File sharing only.

SQL Remote for Adaptive Server Anywhere is available for the following operating systems:

• Windows 95

• Windows NT

• Windows 3.x

• Sun Microsystems Solaris/Sparc

• Hewlett Packard HP-UX

• Silicon Graphics IRIX

• Novell NetWare.

• IBM OS/2

Only the file sharing protocol is available on the UNIX and NetWare operating systems.

  The mobile Intranet

SQL Remote and Sybase PowerDynamo enable the development of mobile intranets. PowerDynamo is a set of tools for building database-hosted Web sites, and these sites can be replicated using SQL Remote onto laptop computers for offline browsing using the PowerDynamo Personal Web Server.

     There are some special considerations when replicating a Web site. For information about using SQL Remote with PowerDynamo, you should read the PowerDynamo User's Guide.