Lattice.SPGen Stored Procedure Generator 1.3

Lattice Business Software Intl., Inc. in Business \ Information Database


Lattice.SPGen is a stored procedure generator wizard that supports Microsoft SQL Server, Oracle and IBM DB2 UDB.


   
 

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 1.3 Information Database software developed by Lattice Business Software Intl, Inc. The license of this information database software is shareware$, the price is 88.00, you can free download and get a free trial before you buy a registration or license. Do not use illegal warez version, crack, serial numbers, registration codes, pirate key for this information database software Lattice.SPGen Stored Procedure Generator. If you want to get a full and unlimited version of Lattice.SPGen Stored Procedure Generator, you should buy from original publisher Lattice Business Software Intl, Inc.


Similar Software

T4S Stored Procedure Generator 1.1.0.3 Tools4SQL.net  Information Database

T4S Stored Procedure Generator reads database schema and generates stored procedures based on your selection and configuration. It supports MS SQL Server 2000, 2005, 2008, MSDE, SQLExpress databases. It is entirely built in C# and .NET 2.0. Key features of T4S Stored Procedure Generator are,...

Lattice.SPGen Stored Procedure and Code Generator 3.0 Lattice Business Software Intl., Inc.  Misc. Inf. Tools

Lattice.SPGen is a template-based stored procedure and code generator that supports Microsoft SQL Server, Oracle, IBM DB2 UDB, PostgreSQL and MySQL.

AutoProc 1.0 Autoproc  Database

AutoProc (Stored Procedure Generator) is a couple of stored procedures which simplifies generating getter and setter procedures for a given Sql Server 2005/2008 table. AutoProc 1.0 License - GNU General Public License (GPL)

Delete Database Users stored procedure 5 4 SQL Soft  Misc. Dev. Tools

Stored procedure compatible with Microsoft SQL Server 2000 and 2005 that automatically deletes unnecessarily users from your database.

EZStoredProcSQL2008 2.0 Ivertech  Utilities

EZStoredProc does not add a number to the end of every parameter of the generated stored procedure. It is a lot smarter in handling primary key, composite keys, and identity column. It does not generate a stored procedure that passes in duplicate parameters when you have both primary key and...

Stored Procedure Access Generator 4 Java 1.0 Spag4j  Misc. Dev. Tools

spag4j is a code generator written in Java to produce Java code for accessing a stored procedure layer from a database. Currently it supports stored procedures written in an Oracle. It produces either an EJB3 Java layer or simple static access methods. Stored Procedure Access Generator 4 Java...

Java Stored Procedure Wrapper for Oracle 1.0 Ejb3spwrapper  Misc. Dev. Tools

Code generator (Freemarker) that parse an Oracle Stored Procedure definition and generates a clean EJB wrapper. Java Stored Procedure Wrapper for Oracle 1.0 License - GNU General Public License version 2.0 (GPLv2)

EZStoredProc 2.0 Ivertech  Utilities

EZStoredProc (pronounced as "Easy Stored Proc") is that magical tool. Unlike the clumsy wizard provided by MS SQL Server Enterprise Manager, EZStoredProc does not add a number to the end of every parameter of the generated stored procedure. It is a lot smarter in handling primary key,...

Query Object Factory 1.0 qof-jdbc.sourceforge.net  Code Management

QueryObjectFactory (QOF) is a lightweight runtime JDBC byte-code generator providing support for CRUD (create, retrieve, update and delete) operations and stored procedure calls. It uses Java annotations to define mappings and is fully OSGi ready.

Generate Scripts 1.0 Deepankar Malik  Server

This application was developed to be a small tool that generates SQL Server stored procedure and table defination scripts.


Popular Software of Business - Information Database

Car Sales Organizer Deluxe 2.5 PrimaSoft PC  Information Database

Car Sales Organizer Deluxe is a Windows software for car dealers, car salespeople. Software helps car dealers to organize, catalog, and manage all car and customer related information. You can quickly access to your auto customer details, easily keep contact notes, track and manage car sales...

ERP software for small company 1.0 Business Database Builder  Information Database

This is ERP software for small to middle size business company operation. This software provides a new affordable way to managing, organizing your company's business flow. It is a Microsoft® Access® based business management software, with 1% cost of regular ERP software, it really will...

MEDI PLUS 9.5 ACCURATE INFO SOLUTIONS  Information Database

MEDICAL BILLING SOFTWARE A Patient Registration, Billing and Management software for Small Hospitals & Nursing Homes. An electronic management in a Hospital or a Nursing Home would require to very precise and must result into cost cutting and efficient management. The idea is to keep you...

MemDB Quotation System 1 MemDB Technology Company  Information Database

MemDB Quotation System helps you to create professional quotation easily. Traditionally, quotation is created by handwriting. Nowadays, many companies are using Excel or Word to create quotation. However, user needs to retype the items or copy and paste items from one quotation to another...

Digital Editions Converter 2.7.1 ebook converter  Information Database

Digital Editions Converter quickly and easily converted ebook to PDF file formats. user can view PDF ebook on other computer or device, user also can print Digital Edition ebook without limitation. it is 1-click converter and easy to use.Our program has simple interface makes conversion into...

RemodelCost Estimator for Excel 3.01 CPR International, Inc.  Information Database

Discover convenience and time-savings while increasing your bidding success.Remodel Construction Cost Estimating System for Excel. Designed specifically for home remodelers, builders, cost estimators and architects. RemodelCOST Estimator contains extensive industry standard user-modifiable unit...

BlackBerry Database Viewer Plus 1 Cellica Software Services  Information Database

View and sync Microsoft Access, Excel, Foxpro,Oracle, SQL Server or any ODBC enabled database on BlackBerry.Update data on BlackBerry. Make a phone call from transferred database.Features:Supported Databases: MS Access, MS Excel, Oracle, SQL Server, FoxPro, dBase, and Any ODBC Compliant Database....

Mobile Database Viewer(Access,xls,Oracle)for S60 1.5 Cellica Software Services  Information Database

View Access,FoxPro,dBase,Excel.Oracle and any ODBC enable Database on S60 mobile phone like Nokia 7650,3650.View database tables: all at a time or record at a time.Features:Apply SQL Select queries on database to purify records by adding filter. View database tables: all at a time or record at a...

ENCORE Clinic Software 6.0.0 Encore eServices  Information Database

ENCORE2002 Medical & Dental Clinic Software System is an advanced Windows based clinic management software system for medical and dental clinics. It enables physicians and clinic managers to efficiently manage their clinics' daily operational needs. Designed for a single-user or multiple...

paradox dbase viewer 2.0.2 sportamok inc.  Information Database

Paradox dBase reader is a versatile viewer for DBF/DB files (Paradox, dBase, FoxBase, Foxpro, Visual Foxpro, Visual DBase,...) With Paradox dBase reader you can view, sort, print dbf file and export the data from them to a variety of formats (TXT, CSV, Excel, HTML, XML, RTF) without using any...