CODEWITHSUNDEEP
replicationsybasesap-asedatabase-replicationsybase-rs
aF.
aF.

Reputation: 66717

How to get Sybase replication definitions code?

How to get the code of all replication definitions of a Sybase server?

If possible and since I'm new to this, give me a little explanation on them as well.

Upvotes: 1

Views: 7398

Answers (2)

Mike Gardner
Mike Gardner

Reputation: 6651

Much of the information about your replication system can be found using the various help functions in the RSSD/ERSSD. The specific commands will vary somewhat based on the kind of Replication you are using (Warm Standby, Function String, Table, Procedure, mixed).

rs_helpdb [ dataserver, database ]: Shows all databases known by the RSSD. If you specify dataserver/datbase, it will only show information for that connection. Output lists Server/Database, rep dbid, primary RS, errorclass, repserver errorclass, function class and status.

rs_helprepdb: Shows replicate databases that have subscriptions to primary data in the current RS, or shows the specified DS/DB.

Other commands that will help:

rs_helprep Displays information about replication definitions

rs_helpsub Displays information about subscriptions

rs_helpreptable Displays information about replication definitions created against a primary table.

rs_helppub Displays information about publications.

rs_helppubsub Displays information about publication subscriptions and article subscriptions.

rs_helpdbrep Displays information about database replication definitions associated with the current Replication Server

rs_helpdbsub Displays information about database subscriptions associated with the replicate data server.

These commands all pull information from the tables in the RSSD, so you can also poke around the RSSD to find the information you are looking for. Here is the RS table diagram to help.

Also, if you are going to do any regular replication work, I highly recommend Rob Verschoors The Complete Sybase Replication Server Quick Reference Guide (www.sypron.nl), as it has >90% of what you need to create and manage a Sybase rep environment.

Upvotes: 3

Vince
Vince

Reputation: 734

  • you can use Replication Monitoring Services (RMS)
  • Various stored procedures and shell scripts for reverse-engineering RepServer objects can be downloaded from http://repserver.codexchange.sybase.com (link 'repserver', folder Admin Tools/Scripts)
  • PowerDesigner provides reverse-engineering but might require a special license

Upvotes: 1

Related Questions