Replicating custom descriptions across multiple DB's?

Documents SQL Server 2000, 2005 and 2008 databases.

Replicating custom descriptions across multiple DB's?

Postby » Wed Aug 21, 2013 3:38 pm

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?
Posts: 1
Joined: Wed Aug 21, 2013 3:32 pm

Postby Manfred.Castro » Thu Aug 22, 2013 4:39 pm

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
Product Support
Red Gate Software
Posts: 209
Joined: Mon Apr 23, 2012 1:49 pm

Return to SQL Doc Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests