Replicating custom descriptions across multiple DB's?

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

Replicating custom descriptions across multiple DB's?

Postby ihayes@ijento.com » Wed Aug 21, 2013 4: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?
ihayes@ijento.com
 
Posts: 1
Joined: Wed Aug 21, 2013 4:32 pm

Postby Manfred.Castro » Thu Aug 22, 2013 5: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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 0 guests