Loading...

Generating Data Dictionary or Database Design Document using MS Word Macros

View: 2096    Dowload: 2   Comment: 0   Post by: hanhga   Category: MS Office   Fields: none

Download  generating-data-dictionary-or.zip (2.98 KB)

You need to Sign In to download the file generating-data-dictionary-or.zip
If you do not have an account then Sign up for free here

The main purpose of this article is to generate the data dictionary document automatically by simply running the macro code in MS Word within seconds.

I am not a VBA guru but I still started doing some kind of researching on VBA code in Google and I got ideas from different forums, many thanks to those people who posted their ideas.

I hope this solution will help you to prepare a data dictionary document. Here we start...

Basically, this code will prepare for you the following information in the document. The table name with the following dependent information:

  • Table Column Details
  • Indexes
  • Views
  • Stored Procedures
  • Functions
  • Triggers
  • Primary Keys
  • Foreign Keys
  • Default Constraints
  • Identity Columns

 

Using the code

Following are the steps to run this code:

  1. Simply open a blank Word document (it is mandatory).
  2. Go to menu Tools->Macro->Macros->Create, this will create a new Visual Basic module editor.
  3. Paste this code.
  4. Change the connection string as per your SQL Server credentials (it is mandatory).
  5. Add references to Microsoft ActiveX Data Objects Library from the menu Tools->References.
  6. Run the macro by pressing F5 from the VBA editor.

 

Generating Data Dictionary or Database Design Document using MS Word Macros

Manually preparing a data dictionary document will take ages in MS Word which contains 100's of tables, stored procedures, functions, triggers, views, indexes, etc. in a SQL Server database as you need to type each and every column of the table along with the associated dependencies. I need a data dictionary document which generates the database schema automatically in one click with nice formatting. For this I did a lot of research in Google to find the solution and finally I wrote my own code to do this functionality and I thought to share my experience with you all.

Posted on 22-03-2014 

Comment:

To comment you must be logged in members.

Files with category

  • Document Library - Enable New Document, Edit Document Features

    Document Library - Enable New Document, Edit Document Features

    View: 2259    Download: 0   Comment: 0

    Category: MS Office     Fields: Other

    In this article we can explore the underlying aspects involved in enabling the New Document feature in a Document Library.

  • Generating Excel (XML Spreadsheet) in C#

    Generating Excel (XML Spreadsheet) in C#

    View: 2785    Download: 2   Comment: 0

    Category: MS Office     Fields: Other

    Recently, I was working on a web based report in ASP.NET. The report had to be generated in MS Excel format and the data was too much. To give you an idea, I had to generate more than 300 worksheets and the file size was more than 5 MB. I tried the...

  • Searching - Human Way and Index Way

    Searching - Human Way and Index Way

    View: 2336    Download: 0   Comment: 0

    Category: MS Office     Fields: Other

    It was really an art to optimize the data retrieval from database and data retrieval optimization is part of every developer's life. Indexes are one of the best ways of Optimization that SQL Servers provide. Understanding indexes some time may be...

  • Creating Pivot Tables and Charts Using ActiveX

    Creating Pivot Tables and Charts Using ActiveX

    View: 2994    Download: 0   Comment: 0

    Category: MS Office     Fields: none

    Most of us (developers) use the “Generate Excel” feature in our applications. This allows us to generate an Excel copy on any of our reports. Most of us are also familiar with “Pivot Table” and “Pivot Charts”. This feature from MS Excel allows the...

  • Automating MS Excel Documents

    Automating MS Excel Documents

    View: 2200    Download: 0   Comment: 0

    Category: MS Office     Fields: Other

    I have been working on automating MS Office applications since some time. I have seen that it is very easy to find information on automation of MS Word but it is difficult to find information on automation of PowerPoint or Excel. So I decided to...

  • Embedding PowerPoint presentation player into a WPF application

    Embedding PowerPoint presentation player into a WPF application

    View: 1481    Download: 0   Comment: 0

    Category: MS Office     Fields: Other

    On one occasion I came across an interesting and, I can even say, challenging task of building a customized player of PowerPoint presentations. This task emerged as part of a project which my teammates and I developed at Reliable Systems. Our...

  • Parallel Processing MS Access VBA Application

    Parallel Processing MS Access VBA Application

    View: 1377    Download: 1   Comment: 0

    Category: MS Office     Fields: Other

    I got a challenging assignment to provide alarm capability on top of an existing application, written in VBA Access. This required a few issues to be dealt with and resolved. I will, in this article, describe the steps I took to provide parallel...

  • Microsoft Office XML formats, defective by design?

    Microsoft Office XML formats, defective by design?

    View: 4054    Download: 0   Comment: 0

    Category: MS Office     Fields: Other

    Microsoft is trying to push new file formats that are using Zip and XML. Are those new file formats any good for Office developers? In other words, should anyone feel safe to make direct access to file parts, and start getting free of running...

 
File suggestion for you
Loading...
File top downloads
Loading...
Loading...
Codetitle - library source code to share, download the file to the community
Copyright © 2018. All rights reserved. codetitle Develope by Vinagon .Ltd