Softworkbench.SPGenerator 1.0 ReadMe File

Softworkbench.SPGenerator is a wizard based code generator. Softworkbench.SPGenerator will process each table and view in the database which you selected and created stored procedures to insert, update, delete, select (single or multiple records) using the fields you choose as well as using stored procedure name you desire. 

Below is how it works:

   * Collect metadata from different datasource 
   * Build xml metadata input definition file 
   * Generate stored procedures using xslt with different xsl stlysheet.  

Main features:

* Control output stored procedures format in runtime by modifying XSL style sheet.
* Change stored procedures name, exclude stored procedures columns on the fly.   
* Auto-generate package header and body for Oracle.
* Auto-generate stored procedures to insert data rows and return identity id for SQL server and sequence number for Oracle. 
* Auto-generate stored procedures to select, update, delete single data row based on primary key definitions. 
* Auto-generate stored procedures to select all rows based on foreign key definitions. 
* Auto-generate stored procedures to select all rows of tables and views.
* Support composite primary key
* Configuration.xml file is used to store RDBMS's basic infomation as well as format of procedure's name
* Last used database infomation was saved back in Configuration.xml file
* New function is added to check if procedure's name exceed 30 characters limit for Oracle
* Option to generate one big sql script file or each file per table

Softworkbench.SPGenerator supports the following RDBMS:
  * MS SQL Server.
  * Oracle.

System Requirements

To use Softworkbench.SPGenerator you should have the following components installed:

   * Microsoft .NET framework 2.0 or newer version.

Thank you for trying out this stored procedures generator tool. 
We hope you enjoy the powerful features of Softworkbench.SPGenerator.

We encourage you to tell us what you like or dislike about the product,
and problems or shortcomings, or even simple comments about anything.

Please report any problems to or any features you would like to see added can be submitted at:

email: info@softworkbench.com

