Tool to Document SQL Server Schema

views:

397

answers:

Tool to Document SQL Server Schema

Can anyone recommend a free (or cheap) program out there which allows me to easily document what certain tables and fields are used for in our applications? Ideally, when we update a fields type, it would automagically update in this tool. Also, showing what fields are indexed etc would be beneficial.

What solutions have you guys / gals used to document your database?

Thanks

Update: we use MS SQL Server 2008

Do you mean to reverse engineer your database schema? Oracle JDeveloper?

Dmitry 2009-11-13 21:40:03

I updated my question. We're using MS SQL Server 2008. I suppose you could consider it reverse engineering. Its just defining the schema so myself and other developers can be on the same page.

Chris Klepeis 2009-11-13 22:11:04

I mean, what do you want to update first, your tables (and update the diagrams/docs) or your diagrams (and generate schema afterwards). Anyway, try JDeveloper or Aqua Studio. They both can do both forward and reverse engineering

Dmitry 2009-11-13 22:35:25

+1 A:

Visio PRO works, and Toad is not very expensive either. You can download Toad for trial. Here are links to procedures for Visio and Toad.

Damir Sudarevic 2009-11-13 22:29:12

+3 A:

Have a look at SQL Doc by RedGate. You document the SQL schema in the tool and it gets stored in the database itself. The schema documentation can then be generated using the tool.

It is not free, but it is relatively inexpensive.

adrianbanks 2009-11-13 22:49:00

ansaurus

tags:

views:

answers:

Tool to Document SQL Server Schema

related questions