July 7, 2008 at 9:32 am
What tool do ya'll all use for managing a Data Diction design (ERD) and the description of fields, etc?
Thanks,
Thomas
Thomas LeBlanc, MVP Data Platform Consultant
July 7, 2008 at 9:36 am
ApexSQL Doc
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 7, 2008 at 10:28 am
Haven't found a great one, but I haven't used Apex's tool. I'd give that a try and see if it helps you. ER/Studio and ErWin haven't worked well for me.
July 7, 2008 at 10:33 am
We use a combination of APex and ER/STudio - this also allows us to manage our audit trail.
July 7, 2008 at 10:33 am
I've been very happy with ER/Studio, but we mainly use it for documentation. All the management stuff that comes with it haven't worked out for us.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 7, 2008 at 10:41 am
If all you need it for is documentation purposes, I use the system tables and output the data in an html format. If someone asks for a data dictionary, I can gen one up real quick.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply