Linked Questions

12 votes
2 answers
4k views

Documenting a giant web of inter-related stored procedures in an MS SQL database: What tool or format? [duplicate]

I hope this is a question with a shorter answer than "Read a 1000 page book", but then, if that's the real situation, then hit me with it. I am not a real DBA, I'm a software developer who is ...
Warren  P's user avatar
  • 1,087
9 votes
6 answers
12k views

Best way to document database mappings for migrations [closed]

I'm working on a project that includes mapping database elements for a migration and I wanted to know what tools others were using to do this? Excel is a very flexible way to document simple ...
eageranalyst's user avatar
7 votes
4 answers
4k views

How to document Oracle database?

I'm new to Oracle databases. I have used to SQL Server and the description fields (MS_Description) for tables and columns for documentation purposes. Is there an equivalent for Oracle? What is the ...
jrara's user avatar
  • 5,333
5 votes
1 answer
2k views

Why is this rollback needed when using sp_addextendedproperty in a stored procedure?

In enter link description here I showed, how I document databases. To insert the extended properties, initially I uses plan sequences of sp_addextendedproperty calls. But lately I wanted to catch ...
bernd_k's user avatar
  • 12.2k
4 votes
4 answers
5k views

How to format documentation in MS_Description extendedproperties?

I'm using a 'MS_Description' extended property to document parameters in a stored procedure. This parameter's documentation requires more structure than just plain text. That is I would like to ...
Kasper van den Berg's user avatar
1 vote
5 answers
854 views

Document database structure for auditors [duplicate]

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 ...
carlo.borreo's user avatar
  • 1,457
0 votes
1 answer
251 views

Documenting SQL Server Database [duplicate]

I wrote the following (Quick and Dirty) script to document a database schema: Note - The relationships part came from another guys site (I just can't remember where). Does anyone know how to ...
Chris's user avatar
  • 11
0 votes
1 answer
869 views

Exporting a Database schema and triggers [duplicate]

I have a small problem at work. Our DBA went on a journey of self-discovery ... I am very happy for him and I hope he finds what he is looking for. But he left us without any information about how the ...
GMark's user avatar
  • 1
0 votes
2 answers
85 views

Useful formats for the results of a database "audit"? [duplicate]

My company has tons of disparate databases - Oracle, SQL Server, and (shudder) MS Access - lying around, and the CIO wants to bring in a third party to track them all down and document them. But, ...
user356676's user avatar
0 votes
2 answers
119 views

Manually documenting a database [duplicate]

I am forced to manually document a legacy enterprise database. Are there some standard good practices or tools to do this? To give you some more context, I have recently been given restricted access ...
zab's user avatar
  • 101