User's Manual

where database_name is the name of the database to take part in
SQL Remote replication.
These two lines set the current database to database_name , so that the
SQL Remote tables are created in the database_name database. The
SQL Remote tables are owned by the database owner.
3. Run the script against your Adaptive Server Enterprise server.
Change to the directory containing the script file and enter the following
command line (which should be entered all on one line) to run the script:
isql -S server-name -U login_id -P password -I ssremote.sql
-o logfile
where server-name is the name of the Adaptive Server Enterprise,
login_id and password correspond to a user with system administrator
permissions on the server who owns the database, and logfile is the name
of a log file to hold the log information from the script.
☞ The login_id must correspond to the name used by the Message
Agent. For more information, see “The Message Agent and replication
security” on page 269.
4. Inspect the log file to confirm that the tables and procedures were created
without error.
The script creates a set of SQL Remote system objects in the database.
The SQL Remote system objects
The script creates the following objects in the database:
♦ SQL Remote system tables A set of tables used to maintain
SQL Remote information. These tables have names beginning with sr_.
♦ SQL Remote system views A set of views that hold the SQL Remote
information in a more understandable form. These views have names
beginning with sr_, and ending in s.
♦ SQL Remote system procedures A set of stored procedures used to
carry out SQL Remote configuration and administration tasks. These
procedures have names beginning with sp_, indicating their system
management roles.
Caution: Do not edit the SQL Remote system tables
Do not, under any circumstances, alter the SQL Remote system tables
directly. Doing so may corrupt the table and make it impossible for
SQL Remote to function properly. Use the SQL Remote system procedures
to carry out all system administration tasks.
22