User's Manual

Chapter 5. A Tutorial for Adaptive Server Enterprise Users

Tutorial: Adaptive Server Enterprise replication

The following sections are a tutorial describing how to set up a simple

SQL Remote replication system.

This tutorial describes the stored procedures used to conﬁgure and manage

SQL Remote. It also describes how to run the

ssxtract

utility to extract

remote databases from a consolidated database and the Message Agents to

send information between the databases in the replication system.

In this tutorial you act as the administrator of the consolidated database, and

set up a simple replication system using the ﬁle-sharing message link. The

simple example is a primitive model for a sales-force automation system,

with two tables. One contains a list of sales representatives, and another a

list of customers. The tables are replicated in a setup with one consolidated

database and one remote database. You can install this example on one

computer.

First steps

Create a login name and

password

To work through the tutorial, you must have system administrator privileges

on an Adaptive Server Enterprise server. The tutorial assumes that your

The tutorial uses the Adaptive Server Enterprise

isql

utility. With the login

name and password as given above, you can connect to your Adaptive Server

Enterprise server using the following command line:

isql -S server-name -U sa -P sysadmin

where

server-name

is the name of the Adaptive Server Enterprise server to

which you connect.

Ensure that you have an appropriate login ID and can connect to your server

before starting this tutorial.

Create a database Create a database named hq on your Adaptive Server Enterprise server with

sufﬁcient space to hold the tables and data required by the tutorial database.

A space of 4 MB is sufﬁcient.

❖ To create a database

1. Using

isql

, connect to the server as a user with system administrator

privileges:

isql -S server-name -U sa -P sysadmin

2. Use the master database: