Geeks With Blogs
Chaz Blogs It's all about the eXperience!

I created a data model in Visio AE 2003 and went through the extremely tedious task of putting a note on just about every column.  Unfortunately when I generated the DDL the notes on the columns were simply generated as commented lines that don't do much more than annotate my DDL. Not exactly what I was hoping for.  So after quite a search on the web I came across this article form Alberto Ferrari.

It seems Alberto had come across the very same problem and decided to put together a nice little console app to parse the DDL and append the needed calls to sp_addextendedproperty statements so that the notes in Visio are added to the Description value of columns in SQL Server.

Nicely done Alberto.  This saved me a lot of work.

--chaz

Posted on Friday, June 5, 2009 3:08 PM | Back to top


Comments on this post: Visio Note To SQL Server Description

# re: Visio Note To SQL Server Description
Requesting Gravatar...
Could you please send me the tool please?

Thanks,

Wendell Sá
Left by Wendell on Mar 19, 2013 2:44 PM

Your comment:
 (will show your gravatar)


Copyright © Chip Lemmon | Powered by: GeeksWithBlogs.net