|
|
 Lattice.SPGen Stored Procedure Generator
Version: 1.3
|
Rating: 5/5 (2 votes)
|
| Author Company: Lattice Business Software Intl., Inc. |
|
| stored procedure, stored procedure generator, stor |
 |
Price: $ 49.00
|
| File Size: 0.23 M |
| Update Date: 8/13/2004 3:06:02 AM |
| Language: English |
| License: Shareware |
| Downloads: 3,179 |
| Limitations: No Expire Date |
| OS: Win95/Win98/WinMe/WinNT 4.x/WinXP |
| Requirements: No special requirements |
| Contact the author latticesoft: info@latticesoft.com |
| Support Email: support@latticesoft.com |
 Download 1  Purchase Now |
   |
|
Description:
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
|
|
Vote for this software: Poor
Excellent
|
|
Releated software search keywords: stored procedure stored procedure generator stor |
|
 |
Version: 1.3
Update: 8/13/2004 3:06:02 AM
Downloads: 3,179
Price: $ 49.00
|
Description:
stored procedure, stored procedure generator, stor |
|
Download Now
Purchase Now
|
|
Version: 2.6
Update: 4/4/2005 8:04:15 AM
Downloads: 2,030
Price: $ 495.00
|
Description:
Automated migration tool to convert Oracle PL/SQL to SQL Server Transact SQL |
|
Download Now
|
|
Version: 2.1
Update: 2/1/2006 8:15:25 AM
Downloads: 1,484
Price: $ 65.00
|
Description:
Import data from MS Excel, MS Access, DBF, TXT, CSV, XML files to MS SQL tables. |
|
Download Now
|
|
Version: 4.45
Update: 11/17/2008 3:00:14 PM
Downloads: 1,292
Price: $ 100.00 $ 90.00 (10% OFF)
|
Description:
Migrates FileMaker to MySQL, Oracle, Access, SQL Server, OpenBase,PostgreSQL |
|
Download Now
Purchase Now
|
|
Version: 8.5
Update: 10/25/2007 6:26:49 PM
Downloads: 945
Price: Free
|
Description:
Tool for Oracle Application Developers |
|
Download Now
|
|
|
Products By Lattice Business Software Intl., Inc.
|
Version: 1.3
Update: 8/13/2004 3:06:02 AM
Downloads: 3,179
Price: $ 49.00
|
Description:
stored procedure, stored procedure generator, stor |
|
Download Now
Purchase Now
|
|
More pages of category Database & Network:
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 |
|