Data Dictionary Creator1.3.4.4

3 MB   9,241 downloads
100% FREE BSD License    
2.9/5 23
Generate documentation reports for your SQL databases and export them to your computer in HTML, XML format or as Excel or Word files

editor's review





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.

Data Dictionary Creator was reviewed by Mihaela Teodorovici
Last updated on January 30th, 2014
Data Dictionary Creator - In the main window of Data Dictionary Creator you can establish the connection to the selected databaseData Dictionary Creator - The Advanced Settings tab allows you to define additional database propertiesData Dictionary Creator - The tool provides users with the option of exporting database documentation to different formatsData Dictionary Creator - Users can import XML and T-SQL databases in order to access and process their contentData Dictionary Creator - screenshot #5

top FREE alternatives

0 User reviews so far.