Storing annotations outside database properties?

Documents SQL Server 2000, 2005 and 2008 databases.

Storing annotations outside database properties?

Postby alexander.oss » Mon Apr 18, 2011 9:00 pm

Is there any way to store annotations made in SQL Doc to a location other than the database being documented (e.g. a local XML file, for example)? I've encountered a problem where I used a copy of our production system in our test environments to create documentation, but when that database copy was overwritten with a fresh version, all of my annotations were of course destroyed.

We don't make changes to our production system except through our standard dev/test/staging process, so I can't just point SQL Doc to our production system.

Posts: 1
Joined: Mon Apr 18, 2011 8:46 pm

Postby Linda Hawksworth » Tue Apr 26, 2011 9:19 am

Unfortunately, there is no option to store extended properties outside of the database being documented. I have a logged feature request with reference SDOC-1437 and will be informed if/when the status of this changes.
Linda Hawksworth
Posts: 192
Joined: Mon Jun 25, 2007 10:32 am

Postby thirster42 » Thu Aug 04, 2011 3:11 pm

Here's how i'm planning on doing my documentation (i'm just now starting this):

Create my initial documentation on a version of the databaase either on my local machine or on dev
Copy the extended properties to dev/test
Any additional documentation will be made on the dev server and then copied up from there (done right before a version push to test)
Posts: 21
Joined: Tue Nov 30, 2010 10:36 pm

Return to SQL Doc Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests