Primary:- ASE01
Stand by:-ASE02
Stand by:-ASE03
Replication Server :-RS157_01
Steps1:- login to REP_Sevre
isql -Usa -PSybase123 -SRS157_01
create connection to ASE03.pubs2
set error class to rs_sqlserver_function_class
set username to pubs_maint
set password to Sybase123
with log transfer on
go
Step2:-To configure/sync login from ASE01 to ASE03
bcp master..syslogins out login.txt -Usa -PSybase123
Step3:- Login to ASE03 for bcp in
isql -Usa -PSybase -SASE03
sp_configure ‘allow updates’,1
go
bcp master..syslogin in login.txt -SASE03 -Usa -PSybase123 -c -b1
Step4:-Then assign maintenance replication_role to pubs2_maint on ASE03
grant all replication_role to pubs2_maint
go
Step5:-create the replication defination on RS157_01 for ASE01
eg.
create database replication definition “ASE01_pubs2_d”
with primary at ASE01.pubs2
replicate ddl
go
create subscription ASE01_ASE03_pubs2_s
for ASE01_pubs2_d
with replicate at ASE03.pubs2 without materialization
subscribe to truncate table
go
check subscription ASE01_ASE03_pubs2_s
for ASE01_pubs2_d
with replicate at ASE03.pubs2
Step6:-To sync the data dump ASE01 pub2 and load at ASE03 pub2
perform refresh from ASE01 to ASE03
Steps7:-
resume connection to ASE03.pubs2
go
Steps8:-Test the replication ,login to ASE01
use pubs2
go
//create the table test at ASE01.pub2
create table test (a int,b int)
go
insert test values(1,2)
go
select * from test
go
Step9:- Now check if the data replicated or not at ASE03
and login ASE03 check
use pubs2
go
select * from test
go
Outpue will be same as we have seen in ASE01
Hello buddy.. congratulations for your blog.. I’ll follow you
LikeLike
Nice description. Do u provide replication training as well?
LikeLike
Hi Pavan
As of now no ..
I am moved into DevOps DBA world and Cloud Engineer role.
LikeLike