Creating an environment

Creating the replication environment involves giving a name to your environment, creating an environment object, setting up permissions, and adding servers.

StepsCreating a replication environment object

  1. In Sybase Central, click the Replication Manager icon in the left pane of the Replication Manager window. The Add Replication Environment icon displays on the Details pane.

  2. Double-click the Add Replication Environment icon in the right pane.

  3. Enter the name of your environment and click Next.

  4. Enter a user name and password that will let you access the environment. Click Next.

    NoteJava does not support the roman8 character set. Do not select roman8 in the character set field for a server connection. Do not select “default” in the character set field for a server connection if the server default is roman8. You must select another character set that is compatible with the server and Replication Manager.

  5. From the list of servers, select the ones to add to your environment, then add a user name and password for each. If you are adding a Replication Server, enter a user name and password for the RSSD. Click Next.

    When adding servers, you must provide a user name and password that have been granted certain permissions:

    • Replication Server – sa permissions.

    • Adaptive Server Enterprise – the sa_role and the sso_role.

    • Replication Server RSSD – the database owner.

    NoteYou can either select a server from the list or enter a server name, host, and port number. This list is from the interfaces file found in the $SYBASE directory.

  6. Check the summary page to make sure you have added all the servers you need. Then click Finish.

NoteYou are not required to add all servers when you create the environment. You can add new servers to an existing environment by using the Add Server wizard.

The new environment object displays in the left pane under the Replication Manager object with the name you assigned.

NoteIf you update the sql.ini or interfaces file while Sybase Central is running, you need only restart the wizard, or reopen any dialog box in progress. You need not restart Sybase Central for the changes to take effect.

StepsDropping a server from a replication environment in Sybase Central

  1. Select the server you want to drop.

  2. Do one of the following:

    • Click the Delete icon from the toolbar.

    • Right-click the selected server, select Delete.

NoteAlthough Sybase Central removes the server from the replication environment’s server list and removes the server icon from the environment, the server is not removed from your replication system. If there are routes or database connections still associated with a deleted server, the server name may still appear in dialog boxes.