How to best document a replication configuration? [closed]

Closed. This question is opinion-based. It is not currently accepting answers.

---

Want to improve this question? Update the question so it can be answered with facts and citations by editing this post.

Closed 5 years ago.

Improve this question

I am looking for suggestions for the best way to document a replication configuration.

Currently the documentation is done in Excel (this sucks), where each dB has a tab & each table is listed in the corresponding dB tab, with ho开发者_开发技巧w it is replicated to/from the data center...etc.

What is the best way (dynamic creation would be GREAT) to do this?

---

I would suggest to look at data from system tables and use them for documentation

Which objects in the database are published?

Publish DB

• SELECT * FROM sysarticles
• SELECT * FROM syspublications

Distribution DB

• Use Distribution
• GO
• SELECT * FROM distribution..mspublications

SubscriberDB

• USE SubscriptionDB
• SELECT * FROM MSsubscriptions
• SELECT * FROM MSsubscriber_info

Hope it Helps.