How to Configure MSA type Database Level Sybase ASE Replication Server Step by Step|How to setup Database level Replication in Sybase ASE

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

Advertisements

3 thoughts on “How to Configure MSA type Database Level Sybase ASE Replication Server Step by Step|How to setup Database level Replication in Sybase ASE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s