Geeks With Blogs
Visual Studio ALM Blog

The title of this post is interesting and something I am wishing you and your colleagues had a better way to do. I understand as I am asked this question frequently. I couple of weeks ago I was asked the same question by a customer who documents their database using the ApexSQL Doc tools which uses the extended properties on objects to create automated documentation. I thought that was super interesting and went down the path to see how we could could support the creation of this documentation while leveraging the Visual Studio 2012 SSDT Tools.

What I found is was rather intriguing. There is a property called “Description” on all objects in the SSDT tools. This property is rather subtle and I am betting overlooked. To be honest, this property has probably been there for a while and I just never discovered it. Adding text to this '”Description” property it allows Visual Studio to create the commands for the extended properties directly to your schema which should be version controlled. As I did more digging there seemed to be extended properties at every level in the SQL database objects.

This fills some rather challenging gaps and allows organizations to manage SQL Schema using the Visual Studio SQL database tools while allowing a way to automatically document the database. This will also work in the automation of the creation and alter scripts that can be generated as part f an automated build system. Now we essentially get a way to store, build and document the database in a nice little ALM package.

Happy Coding!


Posted on Friday, November 16, 2012 8:34 AM | Back to top

Comments on this post: Documenting your database with Visual Studio 2012 SSDT tools

# DiHerbal Online Shop
Requesting Gravatar...
Your publish had provided me with another point of view on this topic. I had simply no strategy that things will most likely work on this form as well. Thank you for sharing your perspective. DiHerbal Online Shop
Left by gerry on Jan 12, 2017 4:47 PM

# Amazon Plus Jus Manggis
Requesting Gravatar...
I would like to appreciate your properly written article it's useful and your writing concept helped me to the idea with no difficulty. Thank you. Amazon Plus Jus Manggis
Left by abdul jalil on Jan 12, 2017 4:49 PM

# K-Muricata
Requesting Gravatar...
I found useful information on this topic as Now i'm focusing on a small business project. Warm regards posting relative information and its currently becoming easier to comprehensive this project. K-Muricata
Left by renny on Jan 12, 2017 4:51 PM

# Amazon Berries
Requesting Gravatar...
We are actively taking care of an assignment and I have been exploring your blog site for several hours. Thank you for your the idea proved valuable for me. Amazon Berries
Left by ferdi on Jan 12, 2017 4:52 PM

Your comment:
 (will show your gravatar)

Copyright © krislankford | Powered by: | Join free