Is there any freeware or features in SQL Server or Visio that can reverse engineer a data dictionary from an existing database?
I had produce a ER diagram using reverse engineer function in Visio, but I still need to produce a data dictionary
I have a similar issue/concern. It looks like Visio 2000 Enterprise can give you a db/schema map but not an actual dd. ERWin and DBArtisan might have some of the features we are looking for. I am still investigating.
You learn anything more on this? Any luck?
Anyone have any more insight into this?
Thanks.
V
You can use Erwin r7 . Do a reverse engineer and filter out for system objects.
HTH
I've been using Jesse hersch's SqlSpec for the past couple of weeks. For $20 it documents most of what I need. I'd suggest checking it out and seeing if, for a pittance, it can give you what you want.
/****************************************************
Check out our Sql Server 2005 and 2000 tutorials
****************************************************/
Visio does a great job at this, but you have to get the one that comes with Visual Studio. Are you looking to generate scripts, just do docs, that sort of thing? You can "roll your own" fairly quickly. Check out this link:
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=108&rl=1
Buck Woody
http://www.buckwoody.com
