Documents SQL Server 2005 and 2008 databases.
Moderators: JonathanWatts, David Atkinson, Michelle Taylor
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 9:46 pm
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.
- Posts: 192
- Joined: Mon Jun 25, 2007 11:32 am
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 11:36 pm
Return to SQL Doc 2
Who is online
Users browsing this forum: No registered users and 0 guests