Documents SQL Server 2005 and 2008 databases.
Moderators: JonathanWatts, David Atkinson, Michelle Taylor
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 4:32 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/
Red Gate Software
- 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 1 guest