Replicating custom descriptions across multiple DB's?

I have a situation where there are four different databases installed that require schema documentation.

The four different databases each have around 150 tables, and of these around 30 are common to each database.

I'm wondering is there a way I can create the common table, column and index custom descriptions once, and then reapply these common descriptions across all four databases?

ihayes August 21, 2013 11:38

Comments

1 comment

For each object, SQL Doc displays the text that is stored in the MS_Description extended property in your SQL Server database.
You could write a script that updates the extended property on the common objects and run it on all four databases.
http://sqlserverperformance.wordpress.c ... rver-2008/

Manfred.Castro August 22, 2013 12:39

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Replicating custom descriptions across multiple DB's?

Comments

Add comment