Tuesday, April 12, 2005

 

Non-Edit Development 4/12/05 - Design???

Well, I'm in the process of putting some finishing touches on v2.16 before I release it this week (finally) and thought I would post an image of another product I'm in the process of working on. This new product I hope to make into a modeling tool specific to SQL Server with features to help the SQL Server Developer and DBA create and manage database models.

Notice how in the Orders table I have turned on additional viewing options so I can see the defaults, rules, check constraints, indexes, and permissions assigned to the table. My goal for the product is to provide a simple and powerful interface for managing/explorer schemas. For example, the product will provide 2 ways to create a new table, simple and detailed. Detailed will work much like other products. Simple will allow the user to simply enter the field names and the app will create the table using the data dictionary to determine types, sizes, nullability, and even FK constraints so that a complete table can be created quickly and accurately without having to specify the settings for every single column.

The product is still in early alpha stages but a lot of the drawing routines have been meshed out. Below is an image of the current schema view of the product. Still have a ways to go, but be on the lookout for this new product which I hope to have available sometime towards the release of SQL 2005.


Comments:
BI Documenter is a SQL Documentation Tool that supports complete metadata documentation of SQL databases, Analysis Services databases and Integration Services projects, including SQL Server 2005.
 
Post a Comment

<< Home

This page is powered by Blogger. Isn't yours?