Database documentation generation

September 1, 2009
User Rating: / 1
Views: 737
PDF Add comments
Share |

DB-VA can produce professional database design documentation in PDF, MS Word 2007 and HTML format. This tutorial shows you how to generate PDF documentation for the Computer Sales database design. The generation procedure of PDF, MS Word and HTML are very similar. You can use the same steps to generate MS Word and HTML by selecting the corresponding menu item under the Report menu.
Topics
1. Select ERD for generating PDF report
2. Customize entities generation order
3. Configure cover page
4. Configure page header and footer

The database design for the Computer Sales project:

Computer Sales project ERD

  1. To generate PDF report, select Tools > Report > Generate PDF Report... from the main menu.
    Generate ERD to PDF report
  2. Specify the output path.
    Specify pdf output path
  3. Uncheck Stereotype in the Diagrams list to not generate stereotypes page.
    Uncheck stereotype in options
  4. Select diagram Physical Database Design to be included in report.
    Select Physical Database Design
  5. Click next to Physical Database Design.
    More selection on selected diagram
  6. Change to sort elements by name by selecting Sort by name.
    Select entity to sort by name in report
  7. Check Launch viewer to auto open the report after the generation.
  8. Switch to the Cover Page tab and fill in the information.
    Specify pdf report cover
  9. Switch to the Header/Footer tab, and click Insert page number at the right hand side of header.
    Specify report header and footer
  10. Page number is added.
    Show page number in pdf report
  11. Click Generate to proceed.
    Generate PDF report
  12. Let's open the generated PDF file. The cover page is generated according to the settings defined in step 8.
    Generated PDF repor of database design
  13. The header and footer are generated according to the settings defined in step 9 and 10.
    Generate ERD in PDF report

Download full functions 30 days FREE trial of DB Visual ARCHITECT

Windows
Linux
Mac OSX

Notes:
1. Select DB Visual ARCHITECT when installing the VP Suite.
2. Click "Try without Evaluation Key" button to get 30 minutes per session evaluation.
3. Click "Request Key" to get a 30-day evaluation key by email (Your email will only be used for sending evaluation key and follow up your evaluation. We will NEVER share your email to third party without your approval).


Microsoft, Microsoft Excel, MS Word and Microsoft SQL Server are U.S. registered trademark of Microsoft Corporation
Oracle is U.S. registered trademark of Oracle Corporation

Comments (0)
Write comment

Name

Email

Title

Comment

Write the displayed characters

security code