Schema Generator

• Download SchemaGenerator.zip - 10.07 KB
• Download SchemaGen_Src.zip - 18.46 KB

Introduction

In this article, I am introducing a small utility developed for the purpose of extracting schema from existing SQL Server database. The basic idea behind developing this utility is to emit the database schema from existing SQL Server database. From developer perspective it is sometimes very much handy to quickly take printout of database structure for creating UI layout or specify some validation rule. If database structure is available in printable format then it will serve the purpose robust programming and effective UI layout, because developer can establish spontaneity between database structure and UI elements. So now lets start exploring the utility in little depth.

After extracting the binary distribution, you will find executable SchemaGenerator.exe. Start the utility from SchemaGenerator.exe.

The first screen will be as follows:

The screen shown above ask the input for :

• Server/Instance name: This will be Server\Instance name. If not specified it will default to (local).
• Database name: This is required input and must specify an existing database.
• Username/Passsword: Optional, provide in case of non trusted connections.
• In SQL server instance specified above.

Now, Fill the Server/Instance name i.e. (local)\SQLEXPRESS.

Click, Generate to produce the report in printable format. Report will be rendered in preview, where one can see the generated schema output then print, if required.

The print preview window output the database structure in printable format, review the format and print if seems accurate in format.

I hope this will help some needful developer and avoid the duplication of efforts.

“Happy computing”

History

Initial revision 1.0 - May 20 2008. Description - Uploaded initial revision

Revision 1.1 - June 04 2008. Description - Updated for new feature of using explicit username and password, in non trusted environment. (Requested by users).

Revision 1.2 - June 05 2008. Description - Fixed the issue of printing reports from Print Preview dialog. (Requested by users).