cancel
Showing results for 
Search instead for 
Did you mean: 

Extract/reverse-engineer the replication definition and subscription codes per database

Former Member
0 Kudos

Look for the SQL/Proc codes or scripts to extract the list of repdef and subscriptions code per each database in the server.


If anyone can share for download, it will be much appreciated. Thanks,

zionas74
Member
0 Kudos

Well I have a 15.6 RS and I use some procedures written a while ago, some are running fine after many patches, others need to be finalized.

Central is dead, you are on your own, or contact me

ZionAsssedo@gmail.com

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

See post

thx

Vincent

Former Member
0 Kudos

Vincent, thanks. Do you have the script to extract the subscriptions list per DS/DB and  their DDL?

Former Member
0 Kudos

Hi

I don't have a script to extract automatically the subscriptions information.

However you could take inspiration from the code of the stored procedures sp_helpdbsub and/or sp_helpsub.

thx

Vincent

c_baker
Employee
Employee
0 Kudos

PowerDesigner has an SRS extension that can reverse the RSSD/eRSSD as part of a Data Movement Model (DMM) to get the RCL.

You may want to look into that.

Chris