10 questions linked to/from How do you document your databases?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...