The documentation tag has no wiki summary.
0
votes
0answers
41 views
SSRS Reports Design Standards and Guidelines Document [closed]
We've just started to create reports for out under developed application using SSRS. To make the layouts, formats, namings, etc consistent across all reports, we should create a Reports design ...
82
votes
14answers
8k views
How do you document your databases?
I find that most of my clients are not documenting their databases at all and I find that pretty scary. To introduce some better practice I would like to know what tools/process you are using.
How ...
4
votes
1answer
132 views
Writing a database analysis document
I've been tasked with writing an analysis of a database that is currently used on a small scale. The intent of the document is to show to the business (as well as technically) that the database can ...
2
votes
0answers
266 views
Where can I find a syntax reference for Oracle SQL Developer's “Generate DB Doc” function?
Oracle SQL Developer (I'm using v3.2) has a feature called "DB Doc", which generates documentation for database objects. I mostly want to use it to generate documentation for my stored procedures, ...
6
votes
3answers
412 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 ...
0
votes
1answer
244 views
Print table documentation with comments?
I have a MySQL database, and I have used MySQL Workbench to insert text into the "comment" fields of many of the columns and tables; the plan was to have the documentation stored in the database.
...
8
votes
3answers
257 views
Documenting a giant web of inter-related stored procedures in an MS SQL database: What tool or format?
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 ...
2
votes
1answer
393 views
log_warnings doesn't seem to work for aborted connections in MySQL 5.1
The docs for 5.1 say that I can set log_warnings = 2 to capture Aborted_connects in the error log. This bug report suggests that this was only merged into 5.5 and 6.0 (and maybe 5.2) but not into ...
3
votes
2answers
154 views
Is index_type ignored on MySQL primary keys in create table?
I have seen a create table whose primary key had an identifier where it should have an index_type, something like that:
create table a (foo INTEGER, PRIMARY KEY foo_id (foo));
The thing is that ...
6
votes
3answers
318 views
Best way to document database mappings for migrations
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 ...
1
vote
2answers
379 views
Question about 'user process' in the context of Oracle
The following is an except from oracle documentation.
Overview of User Processes
When a user runs an application
program (such as a Pro*C program) or
an Oracle tool (such as Enterprise
...
1
vote
1answer
330 views
Can I export a MySQL schema to latex?
I have asked this question on SO before, but did not get a good answer.
I would like to be able to export a MySQL schema to a set of Latex tables.
phpMyAdmin does this, but it is buggy and does not ...
2
votes
2answers
903 views
SQL Server DR Plan - Test Documentation
I have been tasked with creating a document for the testing of our DR/BC Plan for our SQL Servers. We are using DB Mirroring (tier-1) and transaction log shipping (tier-2) and for tier-3 databases we ...
