Chapter 3: Administering ASE Replicator

Creating a primary database connection

If you do not specify a Maintenance User name when you create a primary connection, the ASE Replicator system user is the Maintenance User for the primary connection.

To create a primary database connection with the default Maintenance User

Use sp_addprimaryconn with the following syntax:
```
sp_addprimaryconn "conn_name"
```
where conn_name is the connection name in the form ds.db.

You have the option to specify a different Maintenance User name when you create a primary connection (for example, if the primary database will also act as a replicate database in bidirectional replication).

To specify a different Maintenance User name for a primary connection

Use sp_addprimaryconn with the following syntax:
```
sp_addprimaryconn "conn_name", maint_user
```
where conn_name is the connection name in the form ds.db, and maint_user is the Maintenance User name for the primary database.

Creating a replicate database connection

View this book as PDF