User's Manual

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:
♦ Preparing your server for SQL Remote You must take some steps to
configure your Adaptive Server Enterprise to act as a SQL Remote site.
These include installing the SQL Remote system objects and the stable
queue system objects.
♦ Selecting message types You must decide whether you want to
exchange information by file sharing, e-mail, some other message type,
or a combination.
♦ Ensuring proper permissions are set Each user in the installation
requires permissions on both their own database and on the consolidated
database.
♦ Extracting remote databases You must extract an initial copy of each
remote database from the consolidated database.
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.
20