SQL Remote User's Guide
Setting Up SQL Remote
Preparing your Adaptive Server Enterprise server
For a database in your Adaptive Server Enterprise server to take part in a SQL Remote installation, you must install a number of SQL Remote system tables, views, and stored procedures in your database.
To install the SQL Remote system objects
Locate the SQL Remote initialization script ssremote.sql in your SQL Remote installation directory.
Make a backup copy of the ssremote.sql script file. Then add the following two lines to the beginning of ssremote.sql:
use database_name go
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.
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.
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.