DBSchema Wizard
The DBSchema Wizard provides you the ability to document portions or all of the structure of a SQL database.The output is stored as a static HTML web site that you can publish on a server almost anywhere to provide complete documentation about your database. Access to the database is no longer required for business analysts and process owners in order to discover basic database structure.
Using Microsoft's newest API for SQL Server, the SqlServer.Management.SDK and SqlServer.SMO namespaces provide the ability to completely document the database schema objects. Tables, Views, Stored Procedures and Functions are all selectable so you can grab them all or just a sub-set. The newest API even lets us grab the Description field from the Table Design dialog to allow you full documentation of columns in the tables and how they are related, or if they have any optional values, etc.
Features
Once you select the Server and the Database within that server, the API retrieves all of the standard schema objects (Tables, Views, Stored Procedures and User Functions). After the basic schema is tagged for documentation, you are free to filter the group into sub-sets, or just grab one or two items in each group for a specific task. (See the bullet list below for additional options...)
| |
- Tag/Untag All Tables
- Tag/Untag All Stored Procedures
- Tag/Untag All Views
- Tag/Untag All User Functions
- Status indicators beside each step
- Status indicator showing the current operation
- Build Capability denied until all required data is present
- Select your own graphic for the Entry Screen
- Summary Project Information at bottom of Entry Screen
- Save the output as a project so you can repeat the same set of objects without having to tag them again
|
The DBSchema Wizard provides you the ability to document portions or all of the structure of a SQL database.The output is stored as a static HTML web site that you can publish on a server almost anywhere to provide complete documentation about your database.
Using Microsoft's newest API for SQL Server, the SqlServer.Management.SDK and SqlServer.SMO namespaces provide the ability to completely document the database schema objects. Tables, Views, Stored Procedures and Functions are all selectable so you can grab them all or just a sub-set. The newest API even lets us grab the Description field from the Table Design dialog to allow you full documentation of columns in the tables and how they are related, or if they have any optional values, etc.
If (or when) your schema changes, regeneration of the new documentation will take less than a couple of minutes to produce. Since all but a handful of information is stored in the database, you can quickly provide updates. Our latest enhancement to the application was to store each schema project as a separate file so you can quickly regenerate a subset of a database without having to retag all of the components you wish to include.
Check out this product at Snowcovered. While it is not a DotNetNuke specific product or module, it is extremely easy to document applications and additional structure added to a DNN site with this utility.