Configuring Replication Server for replication to the target database

This section describes the required configurations for Replication Server for replication to the target Microsoft SQL Server database.

To create a Replication Server connection to replicate

Navigate to the Replication Agent scripts directory: %SYBASE%\REP-15_0\scripts.

Make a copy of the hds_msss_connection_sample.sql script:

cp hds_msss_connection_sample.sql my_mssql_create_rs_repl_connection.sql

Before executing the my_mssql_create_rs_repl_connection.sql script against your Replication Server, change the msss_dco.dbname to the name of the connection that Replication Server uses to connect to the DirectConnect access service, where:

msss_dco is the DirectConnect access service name.

dbname is any valid identifier. Sybase recommends that you use the Microsoft SQL Server replicate database name.

maintuser and password are the maintenance user and password created in ECDA Option for ODBC in step 1 of “Creating a maintenance user for replication”. For example:

create connection to msss_dco.dbname set error class rs_sqlserver_error_class set function string class rs_msss_function_class set username maintuser set password "password" set batch to "off" with log transfer on go

In the previous example, password is a Replication Server reserved word and therefore, must be enclosed in double quotes.
Create the connection to the replicate database using the Sybase isql utility:
```
isql –Usa –P –SSAMPLE_RS -i my_mssql_create_rs_repl_connection.sql
```
To verify the Replication Server connection to the replicate database, log in to SAMPLE_RS and verify the Replication Server connection to the replicate database:
```
isql –Usa –P –SSAMPLE_RS
```
```
admin who
```
```
go
```
You should see a message returned for the DSI connection msss_dco.dbname. Verify that the status is “Awaiting Message” or “Awaiting Command.”
Exit the isql session with the quit command.