Document database structure for auditors

Question

I am DBA for a Microsoft SQL Server 2008r2. Due to an audition, I need to provide data structure of my database, to people without an explicit IT background. I guess they would like the traditional format, with the tables as rectangles, with the fields listed inside, and the arrows between them to represent foreign keys. Is this something that is provided out-of-the-box by Microsoft?

score 5 · Accepted Answer · answered May 13 '13 at 08:32

5

In SQL Server Management Studio Object Explorer, expand a database and look at "Database Diagrams" to create one.

This require db_owner rights which you should have as a DBA (a.k.a sysadmin)

answered May 13 '13 at 08:32

gbn

70,237
8
167
244

score 2 · Answer 2 · answered May 13 '13 at 11:32

If you can present it in a file format and not as a diagram, then have a look at DBScribe

I am particularly fond of the .CHM type output file, as it lists not only the tables with columns and data type, but also gives links to the dependencies.

Raj

score 1 · Answer 3 · answered May 17 '13 at 08:36

1

I ended up using a combination of Techwriter and of Server Studio's own database diagrams.

http://www.adivo.com/techwriter-for-databases.aspx

answered May 17 '13 at 08:36

carlo.borreo

1,477
6
22
37

score 1 · Answer 4 · edited Feb 18 '19 at 09:29

SchemaCrawler for SQL Server is a free tool that generates diagrams of tables selected by means of regular expressions. I recommend that you generate more than one diagram, per "domain" in your system - for example, one diagram each for customers, sales, orders.

Here is an example diagram:
_{(source: github.io)}

In addition, SchemaCrawler can also generate human readable HTML documentation of your schema.

Sualeh Fatehi, SchemaCrawler

score 0 · Answer 5 · edited Sep 21 '16 at 03:11

It's not a direct solution your request but once you will have diagrams you can paste them into Dataedo documentation and generate nicely formatted document for auditors. (I'm the product manager of Dataedo.)

It will have detailed documentation of all database objects (with descriptions imported from DBMS) and your diagrams. You will be able to furtner descibe any other elelment.

Sample documentation: PDF

enter image description here

Document database structure for auditors

5 Answers5