Create the connection to the primary and replicate databases

  1. Use the Replication Server rs_init utility to create the Replication Server connection to the Adaptive Server database that will act as the primary database. See the Replication Server Configuration Guide to use rs_init.

  2. Create the connection to the replicate Sybase IQ database.

    NoteYou cannot use rs_init to create the connection to Sybase IQ.

    This example uses the iqdb database in the IQSRVR data server, and the default dbmaint Sybase IQ maintenance user.

    create connection to IQSRVR.iqdb
    using profile rs_ase_to_iq;standard
    set username to dbmaint
    set password to dbmaint
    go
    

    If the command is successful, you see:

    Connection to ‘IQSRVR.iqdb’ is created.
    

    See “create connection with using profile clause,” in Chapter 3, “Replication Server Commands” in the Replication Server Reference Manual.

    Verify that the connection is running:

    admin who
    go
    

    If the connection is running, you see:

    Spid   Name       State              Info
    ----   --------   ----------------   -----------------
     63    DSI EXEC   Awaiting Command   103(1)IQSRVR.iqdb
     62    DSI        Awaiting Message   103 IQSRVR.iqdb
     35    SQM        Awaiting Message   103:0 IQSRVR.iqdb