开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜