The first thing to do is to add the dataserver connection settings into the Replication server interfaces file.
You also need to add the replication interfaces file entry into the primary dataserver interfaces file

You then need to make sure the maint users are created in the primary and replicant servers, add the password details into the .sybinfo file

Next grab the passwords for sybadmin for both servers and also the rs SA and Repagent logins

Make sure that there is no repagent/secndary truncation point configured on the primary, if there is then remove them with sp_config_rep_agent sierra, “disable” and dbcc settrunc (ltm,ignore)

You should now be ready to run rs_init for both the primary and replicant

After the connections are created you need to disable the firing of any triggers on the replicant side with:
alter connection to .
set ‘dsi_keep_triggers’ to ‘off’

Reptostandby does not need to be executed. We only replicate at the table level and not the db level. So DDL changes are not replicated.

So set any individual tables for replication in the primary database with:
sp_setreptable fnxaudittnum, true
sp_setreptable fnxauditdet, true
sp_setreptable fnxauditgrpsub, true
sp_setreptable fnxauditgrp, true
sp_setreptable fnxaudtype, true
sp_setreptable fnxaudit, true

If it is not already running Start up the Repagent on the primary and ensure it is up and running (sp_help_rep_agent) and also check in Repserver.

The repdef, subscription and any function string class scripts etc are stored in directory /sybdba/sybase/dba/replication so create them first, perhaps copy from somewhere else.

Once they are ready execute first the database repdef and function_string class script against the Repserver

Next create the subscription with dump_marker from the script above

Now we need to dump and load the database

Dumps seem to be located in directories under for example /datlib///

so just create a new subdirectory, like sierra_DS16-19, and on the dataserver issue the dump with the following:
dump database sierra to ‘/datlib/cam_sybdmp_uat01//.dmp.s1’
stripe on ‘/datlib/cam_sybdmp_uat01//.dmp.s2’
stripe on ‘/datlib/cam_sybdmp_uat01//.dmp.s3’
with compression=100
go