This section describes the configuration tasks for configuring Replication Server for Microsoft SQL Server.
To apply heterogeneous datatype support (HDS)
scripts to RSSD
Prepare the Replication Server RSSD for replication to a Microsoft SQL Server database. To apply HDS support scripts to RSSD:
Set the environment variables by executing the SYBASE.bat file.
Change to the %SYBASE%\REP-15_0\scripts directory:
Load the following scripts into the RSSD:
isql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps –SSAMPLE_RS_ERSSD –ihds_clt_ase_to_msss.sql -DSAMPLE_RS_ERSSDisql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps –SSAMPLE_RS_ERSSD –ihds_msss_udds.sql -DSAMPLE_RS_ERSSDisql -U SAMPLE_RS_RSSD_prim -P SAMPLE_RS_RSSD_prim_ps –SSAMPLE_RS_ERSSD –ihds_msss_funcstrings.sql -DSAMPLE_RS_ERSSD
Shut down Replication Server:
isql –Usa –P –SSAMPLE_RS shutdown go
Navigate to the %SYBASE%\REP-15_0\samp_repserver directory:
Run the RUN_SAMPLE_RS script, to start the SAMPLE_RS Replication Server.
