Contents Index Setting Up SQL Remote Preparing your Adaptive Server Enterprise server

SQL Remote User's Guide
  Setting Up SQL Remote

Setup overview


We call the collection of databases exchanging information using SQL Remote an installation. From a physical point of view, a SQL Remote installation may consist of hundreds or even thousands of databases sharing information; but as SQL Remote keeps the information in each physical database loosely consistent at a transactional level with that in other physical databases, you can also think of the whole installation as a single dispersed database.

Deploying a large-scale SQL Remote installation can involve setting up databases on many machines. While some changes to the design and setup configuration can be made on a running installation, it is highly recommended that you deploy only when you have completed a careful analysis and test of your design.

Setup tasks 

Setup of a SQL Remote installation includes the following tasks:

This chapter describes each of these tasks.

All administration is at the consolidated database 

Like all SQL Remote administrative tasks, setup is carried out by a database administrator or system administrator at the consolidated database.

The Sybase System Administrator should perform all SQL Remote configuration tasks. See your Adaptive Server Enterprise documentation for more information about the Adaptive Server Enterprise environment.


Contents Index Setting Up SQL Remote Preparing your Adaptive Server Enterprise server