Linked Questions
10 questions linked to/from How do you document your databases?
0
votes
1
answer
768
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 ...
CommunityBot
- 1
0
votes
2
answers
103
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 ...
- 101
4
votes
3
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 ...
- 80.3k
1
vote
5
answers
852
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 ...
- 2,181
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 ...
- 103
0
votes
1
answer
249
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 ...
- 80.3k
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 ...
- 80.3k
0
votes
2
answers
84
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, ...
- 31.4k
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 ...
- 3,031
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 ...
CommunityBot
- 1