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 the
standby database
Navigate to the Replication Server scripts directory: %SYBASE%\REP-15_1\scripts.
Make a copy of the hds_msss_connection_sample.sql script:
copy hds_msss_connection_sample.sql my_hds_msss_connection_sample.sql
Before executing the my_hds_msss_connection_sample.sql script against your Replication Server, change {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 the Microsoft SQL Server standby database name.
rs_maint_user and rs_maint_user_pwd are the maintenance user and password created in step 1 of “Creating a maintenance user for replication”. For example:
create connection to my_standby_mssql_service.standby_db 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" 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 standby database using the Sybase isql utility:
isql –Usa –P –SSAMPLE_RS -i my_hds_msss_connection_sample.sql
To verify the Replication Server connection to the standby database, log in to SAMPLE_RS and verify the Replication Server connection to the standby database:
isql –Usa –P –SSAMPLE_RS
admin who
go
You should see a message returned for the DSI connection my_standby_mssql_service.standby_db:
Spid Name State Info
---- --------- ---------------- --------------------------------------
14 DSI EXEC Awaiting Command 101(1) SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
10 DSI Awaiting Message 101 SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
9 SQM Awaiting Message 101:0 SAMPLE_RS_ERSSD.SAMPLE_RS_ERSSD
19 DSI EXEC Awaiting Command 102(1) my_standby_mssql_service.standby
18 DSI Awaiting Message 102 my_standby_mssql_service.standby_db
17 SQM Awaiting Message 102:0 my_standby_mssql_service.standby_
11 dSUB Sleeping
6 dCM Awaiting Message
7 dAIO Awaiting Message
12 dREC Sleeping dREC
21 USER Active sa
5 dALARM Awaiting Wakeup
13 dSYSAM Sleeping
Verify that the status is “Awaiting Message” or “Awaiting Command.”
Exit the isql session with the quit command.
