Replication Sybase Server Installation Configuration

Source: Internet
Author: User
Tags sybase

I've been looking at Sybase this version, and it's really good, though no one answered the two questions I asked. Found a lot of replication problems, write a contribution:
Sybase version has no proprietary FTP, I upload replication server 12.0 for win, as if someone to
Specific replication steps:
1. Install PRS, is ID SERVER,RSSD need to replicate (REP agent) PDB to replicate (REP agent)
2. Install RRS, not ID SERVER,RSSD do not copy.
3. Build Prs->rrs single route, build on PRS;
Isql–usa–ppass–sprs
>create route to RRS
>set username Rrs_rsi
>set Password Rrs_rsi_ps
>go
4 Build a replication user in the PDS (primary data server):
Isql–usa–ppass–spds
>sp_adsdlogin Repsys,repsys_ps
>go (repsys password Repsys_ps)
>use PDB
>go
>sp_adduser Repsys
>go
>grant all in rep_table to Repsys
>go (rep_table Authorization for tables to be replicated)
5 Add the replication user Repsys to the PRS (primary replication server) RRS (replication point Replication Server) and grant the Create object permission to the user. (Note that this "Repsys" user must use the same login name and password on PRS and RRs and PDS)
Isql–usa–ppass–sprs
>create User Repsys
>set Password Repsys_ps
>go
>grant Create object to Repsys
>go Isql–usa–ppass–srrs
>create User Repsys
>set Password Repsys_ps
>go
>grant Create object to Repsys
>go
6 Create a replication definition on the PRS (note the user)
Isql–urepsys–prepsys_ps–uprs
>create Replication Definition Pdb_repdef
>with Primary at Pds.pdb
>with all table named ' Rep_table '
> (num1 datatype,num2 datatype,.......)
>primary key (NUM)
>searchtable columns (num1,num2,......)
>go
7 make the table that the PDB in the PDB is replicated to be replicated
Isql–usa–ppass–spds
>use PDB
>go
>sp_setreptable Rep_table,true
>go
8 authorizing tables to be replicated in RDB in RDS
Isql–usa–ppass–srds
>use Rdb
>go
>grant all in rep_table to Rdb_maint
>go
9 Build a reservation on the RRS
Isql–urepsys–prepsys_ps–srrs
>create Subscription Pdb_sub
>for Pdb_repdef
>with Replicate at Rds.rdb
>subscribe to TRUNCATE TABLE
>with materialization (initialization)
10 verification on PRs and RRS
Isql–usa–ppass–sprs
>admin_health
>go
>admin_who
>go
>admin_who_is_down
>go

Isql–usa–ppass–srrs
>admin Health
>go
>admin who
>go
>admin Who_is_down
>go
It's easy to write, please correct me if you have any questions. In fact, copying is really easy. There are any questions to explore.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.