Setting up the database for Replication Server

Once you have created your SQL Anywhere database and created the necessary tables and so on within the database, you can make the database ready for use with Replication Server. You do this using a setup script supplied with the SQL Anywhere Replication Agent product. The script is named rssetup.sql.

When you need to run the setup script

You need to run the setup script at any SQL Anywhere database that is taking part in a Replication Server installation, whether as a primary or a replicate site.

What the setup script does

The setup script creates user IDs required by Replication Server when connecting to the database. It also creates a set of stored procedures and tables used by Replication Server. The tables begin with the characters rs_, and the procedures begin with the characters sp_. Procedures include some that are important for character set and language configuration.


Prepare to run the setup script
Run the setup script