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

# obat tradisional ginjal bocor
Requesting Gravatar...
The world will be altering fast. people are also being by day we are becoming more dependant on degital are making me think of this really.You have a pleasant technique of sharing your thoughts. obat tradisional ginjal bocor
Left by Toko Herbal Veherba on Jan 23, 2017 3:51 PM

# pengobatan jantung bengkak
Requesting Gravatar...
I really enjoy simply studying all of your weblogs. Simply wanted to inform you that you've people like me who appreciate your work. Definitely a fantastic publish. The information that you have provided is very useful. pengobatan jantung bengkak
Left by Toko Herbal Online Veherba on Jan 23, 2017 3:52 PM

# obat kolesterol tinggi
Requesting Gravatar...
Very nice article. I just bookmark your blog site and want to says that I have truly enjoyed browsing your weblog posts. Cheers
Left by Toko herbal Terlengkap Veherba on Jan 23, 2017 3:53 PM

Your comment:
 (will show your gravatar)

Copyright © krislankford | Powered by: