Data Dictionary Creator
Data Dictionary Creator assists you throughout the process of creating documentation for your SQL database, which includes explanations of what each table is for and information on the database structure. Its main advantage is that it can keep the documentation updated at all times, since it stores data in the Extended Properties section.
An alternative is to generate a database diagram, but when working with large databases that comprise a larger number of tables, this is practically a waste of time.
Data Dictionary Creator features a tab-based interface that can guide you through each step required for creating a HTML, Excel, Word or XML report to represent the configuration of your database.
To begin with, you have to enter the database connection details and set up the connection. Then, you can proceed straight to manually documenting your database, but you might want to take a look at the 'Advanced Settings' section first, since it includes some options that can help you automate some actions and thus, save time.
To be more specific, the application features auto-fill functions that generate a description for all primary and foreign keys and offers you the possibility to add more properties to the documentation, aside from the 'Description' field (for instance, owner, creation date etc.).
The application displays each column in a table, data types and descriptions, allowing you to modify the documentation fields and saving the progress with each change. Once the documentation is ready, you can export it to your computer in one of the aforementioned formats.
Data Dictionary Creator provides you with a convenient way to keep database documentation in sync with tables and columns. It is a reliable tool for those who work with Microsoft SQL Server, allowing the quick documentation of databases.