Lattice.SPGen Stored Procedure Generator 1.2

Lattice.SPGen is a stored procedure generator that supports Microsoft SQL Server, Oracle and IBM DB2 UDB. Lattice.SPGen 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 procedureiZs name you desire. Below is how it works: ah Collect metadata from different datasource(Oracle, DB2, SQL Server) ah Build xml metadata input definition file ah Generate stored procedures using xslt with different xsl stlysheet. Key features: * Supports Oracle 8i/9i, SQL Server 7/2000/MSDE and IBM DB2 UDB. * Control output stored procedures format at runtime by modifying XSL style sheet. * Change stored procedure's name, exclude stored procedure's columns you desire. * Auto-generate package header and body for Oracle. * Auto-generate stored procedures to insert data rows and return identity id for SQL server and DB2 UDB as well as 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.

Requirements:	No special requirements
Platforms:	Windows 2000, Windows XP
Keyword:	C#,  Code Generation,  Code Generator,  Database,  Database Browser,  Databases,  Development,  Generate Code,  Generation,  Java,  Model,  Mysql,  Oracle,  Php,  Postgresql,  Programming,  Rapid,  Schema,  Sql Editor,  Sql Server,  Stored Procedure,  Stored Procedure Creator,  Stored Procedure Generator,  Stored Procedures,  Template
Users rating:	0/10