Creating a primary database connection  Deleting a database connection

Chapter 3: Administering ASE Replicator

Creating a replicate database connection

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

StepsTo create a replicate database connection with the default Maintenance User

  1. Use sp_addreplicateconn with the following syntax:

    sp_addreplicateconn "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 replicate connection.

StepsTo specify a different Maintenance User name for a replicate connection

  1. Use sp_addreplicateconn with the following syntax:

    sp_addreplicateconn "conn_name", maint_user, maint_pw
    

    where conn_name is the connection name in the form ds.db, maint_user is the Maintenance User name for the replicate database, and maint_pw is the password for the Maintenance User.

NoteIf you specify a Maintenance User name that does not already exist as an external login on the primary Adaptive Server, ASE Replicator creates an external login for the Maintenance User name you specify.





Copyright © 2005. Sybase Inc. All rights reserved. Deleting a database connection

View this book as PDF