Lattice.SPGen Stored Procedure Generator 1.3
 |
Type: Shareware Cost: 88.00$ Released: 2004-08-12
|
|
|||||||||
|
Rated by: 0 user(s) Rating: NOT RATED  |
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
Related downloads:
#1 MySQL GUI - Navicat MySQL administrator Manager (supports Access to MySQL conversion) - Navicat (MySQL Client - a GUI Tool for MySQL admin and Access to MySQL, Excel to MySQL conversion). Navicat is a set of graphical database management, reporting and monitoring tools for MySQL database systems. Navicat is easy-to-use, powerful and supports HTTP and SSH for remote MySQL connection.
Passwords-Lines - Store and encrypt passwords, account number for credit cards, insurance, mtg, loans, leases. Save important data for retrieval. Encrypt and Decrypt at will.
DBF to XLS (Excel) - The DBF to XLS (Excel) program allows you to convert your dbf files to XLS (Microsoft Excel) format.
Advanced Access Repair - Advanced Access Repair is a powerful Access recovery tool. It uses advanced technologies to scan the corrupt Microsoft Access databases(.mdb files) and recover your data in them as much as possible, so to minimize the loss in file corruption.
microOLAP Database Designer for MySQL - Visual development system intended for database design, modeling, creation, modification and reverse engineering in an easy and powerful way. Accelerates the process of database creation and makes it clear, simplifies MySQL database maintenance.
 |
|||||||||||||||||||||||||
 |
|||||||||||||||||||||||||
| |||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
