Lattice.SPGen Stored Procedure Generator

download home page
developer:Lattice Business Software Intl Inc
license:Shareware
version:1.3
size in Kb:235
price:$88
 
platform: Windows, Windows XP
downloads:228
our rating: n/a
popularity:
1220/2048271
link error:Report
Lattice.SPGen Stored Procedure Generator

Rate me

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 fileMain 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 keyLattice.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=13Lattice Business Software http://www.latticesoft.com


More Downloads Related to Lattice.SPGen Stored Procedure Generator

Db2 - Database Tool - Code Generation - Stored Procedure Development - Oracle Package

GiPo@DB_Utilities GiPo@DB_Utilities is a set of utilities for Windows 95/98/ME/NT/2000/XP that provide an easy way to work with different OLE DB- and ODBC-compatible databases and data sources such as Microsoft SQL Server 7.0/2000, Oracle DBMS, Informix, MySQL, DB2, Microsoft Access, dBase, Paradox, FoxPro, Visual FoxPro and ...

Visual SQL-Designer Visual SQL-Designer is a program for easy visual constructing hard SQL-query for any database and write it. Support ORACLE, MS-SQL server 6.5-7.0-2000, MySQL,SyBase, Db2 for NT, MSAccess and other ODBC databases. Union query builder. OLAP inside. Make Table SQL-query builder. Export of the data of ...

DBReader DBReader is a hierarchical database browser with editing capabilities.DBReader provides the end user with a fully integrated set of development tools for data manipulation and data definition. Complete with a metadata view of the underlying data structure, the end user is presented with a total ...

Database DBxq DBxq (formerly Cute DB Explorer) enables you to connect to one or more relational databases and view database information in an integrated environment, and helps you to create, edit, organize and execute reports of any query statement easily and quickly. You can find any table, ...

EngInSite MySQL Client Defining and managing the database-structure, importing data, editing data is now as simple as can be. For designers with only a basic grasp of databases, this program is the way to go, without the need for SQL gurus. What makes EngInSite MySQL Client a cut ...

Database Exchange Wizard Data Exchange Wizard imports data from a text file, a Microsoft Excel spreadsheets, or a Microsoft Access databases into any database, including Oracle, MS SQL Server or any ODBC compliant database. Alternatively, data from Oracle, MS SQL Server or any ODBC source can be exported ...

SqlDbx SqlDbx is a fast and easy to use database SQL development IDE for database administrators and application or database developers who work in heterogeneous Database Server environments. SqlDbx built around an advanced SQL Editor and Database Object Explorer. SqlDbx provides a consistent user interface between ...

SQLTools 1.4.1 SQLTools is a light weighted and robust tool for database development. It includes a text editor, an sql console and a couple of sql utilities. You can use it for dial-up connection and it will work as fast as SQLPlus. It is small and not ...

Orbital's SQL Decryptor Orbital's SQL Decryptor is the first product to decrypt SQL triggers, views, user defined functions and stored procedures in an easy to use Enterprise Manager-like graphical interface. It works quickly to decrypt items in Microsoft« SQL Server 6.5, 7.0, 2000, 2005 and MSDE. Orbital's SQL ...

SqlAnswersMail SqlAnswersMail supports PDF and HTML formats. When using PDF, you can configure a number of different properties such as page width, length, orientation, size to content, page header, page footer, etc. When using HTML, you can configure the exact presentation of your email using a ...

Send Mail Expert Send Mail Expert have supper randomize: From name, From emails, Subjects, Reply to, Proxy,IP address, Email Header,Email Body,... All such randomization will guarantee that your email will bypass all the filters (Junk Mail Filter, Block List...) and delivered safely to your customers. Send Mail Expert ...

AWBot AWbot connects to your web site and make URL requests like any other visitors.AWBot is not a web indexing robot but a web client tool that emulate some visitors browsing on your web site to test its stability after a development change, to test its ...


Latest Downloads from Lattice.SPGen Stored Procedure Generator publisher Lattice Business Software Intl Inc

Lattice.DataMapper Lattice.DataMapper is a tool that maps .NET objects to and from an underlying relational database using external XML configuration and mapping files. The data access is externalized in XML and can include both SQL queries and stored procedure...

New software

Popular software

Current software picks