About Qweas     RSS Feeds     BBS Forum Make Qweas.com My Home Page     Bookmark this page Register     Login     Help     Send Feedback  
Windows   Mac   Linux   Mobile   Games   Screensavers
Audio/Video Business Communication Desktop Develop Education Games Graphic Home Network Security Servers System Web
Accounting & Finance , Calculators & Converters , Databases & Tools , Helpdesk & Remote PC , Inventory & Barcoding , Investment Tools , Math & Scientific Tools , Office Suites & Tools , Other , PIMS & Calendars , Project Management , Vertical Market Apps
Recommends
AppleXsoft File Recovery for Mac

SoundTaxi Pro+VideoRip

outlookEMLandMSGconverter

PSP Movie Creator

ImTOO Video to Picture for Mac

Web Camera Security System

RegEditor

Joboshare DVD Copy

MiniLyrics

Noah's Ark Deluxe

Photo to Cartoon

Registry Help Pro

Related Reviews - more
xml generator

barcode generator

keyword generator

password generator

database management

database monitoring

backup database

database administrator

database development

database connect

database applications

database designer

database optimization

database access tools

invoice software

invoice creator

personal finance software

business finace software

finance management

accounting management

financial analysis

check tools

rate calculators

liquidity calculators
Home > Business > Databases & Tools > Lattice.SPGen Stored Procedure Generator

Detailed Description of Lattice.SPGen Stored Procedure Generator 1.3


Lattice.SPGen Stored Procedure Generator 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 procedure's name you desire. Below is how it works:

1. Collect metadata from different datasource(Oracle, DB2, SQL Server)
2. Build xml metadata input definition file
3. Generate stored procedures using xslt with different xsl stlysheet.

Features added in version 1.3

* Option to generate business entity class per table
* Option to generate one big sql script file or each file per table
* Option to generate XML metadata definition file

Main features:

* Control output stored procedures format in runtime by modifying XSL style sheet.
* Change stored procedure's name, exclude stored procedure's 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

Lattice.SPGen 1.3 supports the following RDBMS:
* MS SQL Server 2000 and 7, MSDE 2000.
* Oracle 8i and 9i.
* IBM DB2 UDB

Below is the link to download the software:
http://www.latticesoft.com/DesktopDefault.aspx?tabindex=4&tabid=13


Lattice Business Software
http://www.latticesoft.com



Lattice.SPGen Stored Procedure Generator is designed for:
WinOther,Win98,Win2000,WinXP,WinServer


TAGS OF LATTICE.SPGEN STORED PROCEDURE GENERATOR

pdf generator , key generators , key generator , web template generator 1.0 , php generator , parallels generator mac free only , html generator , ebiz assets sales copy generator , youtube hit generator









Site Map | Sort by Letters | Submit Software | Popular Downloads | Editor Picks | New Releases : Mac , Freeware | Updates : Mac , Freeware
Copyright © 2005-2012 Qweas Inc. All rights reserved. Get Buttons - Link to Us - About Qweas - Contact Us - Terms of Service - Copyright Policy - Guidelines - Privacy Policy