Lattice.SPGen Stored Procedure Generator 1.3 - at datapicks.com




Lattice.SPGen Stored Procedure Generator
Download link
Size 235KB
License Shareware
Price 88
Category 0 / 0
Operating System Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003
Developer Lattice Business Software Intl., Inc.


   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


     Related keywords: stored procedure, stored procedure generator, stored procedure builder, stored procedure creator, stored procedure wizard, SQL Server, Oracle, DB2, database tool, stored procedure development, oracle package, code generation, xslt, xml,

  
Top Others / Software Development programs
  • Hexadecimal to ASCII Converter  1)   Hexadecimal to ASCII Converter 4.3.4
    Convert hexadecimal strings to ASCII text with a single click. Small application window allows simultaneous use with your favourite IDE, text editor, Word, etc..

  • Free Serial Port Monitor  2)   Free Serial Port Monitor 3.31
    Free software serial port monitor, Com Rs232 sniffer with communication packet data analyzer. This monitoring utility can spy, capture, view, analyze, test com ports activity performing com port connection and traffic analysis

  • SimpleOCR  4)   SimpleOCR 3
    Convert your scanned images to text files or Word documents with SimpleOCR--the only OCR (Optical Character Recognition) application that is completly free. SimpleOCR is also a royalty-free developer toolkit (aka SDK or API).

  • Docklight RS232 Terminal - RS232 Monitor  5)   Docklight RS232 Terminal - RS232 Monitor 1.6
    Docklight is a test, analysis and simulation tool for serial communication protocols (RS232, RS485/422 and others). * Simulating serial protocols * Logging RS232 data * Detecting specific data sequences * Responding to incoming data

  • Chilkat Character Encoding Conversion ActiveX  6)   Chilkat Character Encoding Conversion ActiveX 9.1.0
    ActiveX component for converting text and HTML from one character encoding to another. Supports all western languages, Chinese, Japanese, Korean, Hebrew, Arabic, Thai, Vietnamese, Russian, Cyrillic, Greek, Unicode, utf-8 and more.

  • VEDIT  7)   VEDIT 6.13.1
    VEDIT edits any text, data, binary file in ASCII, Hex or EBCDIC; even 100+ Gigabyte files. Ideal for database and mainframe editing, program development. Fast, compact and configurable. Windows, DOS, Linux

  • MCCombox  8)   MCCombox 3.04
    MCCombox is an Access style multi column combobox for all your projects in Visual Basic, C++, etc... to help you to easily build professional data entry screens.Use MCCombox whenever you need a flexible and powerful text input validation.

  • Virtual Tree  9)   Virtual Tree 2.5
    Combined Tree/ListView for .NET with advanced data binding capabilities and unmatched performance displaying large data sources.

  • Chameleon Button  10)   Chameleon Button 2.1.6
    The Chameleon Button is the custom command button that will make the difference in your Visual Basic applications. It includes 18 different button styles, and has many advanced features that made it the chosen tool to enhance the user interface.



New Others / Software Development programs
  • GraphEditPlus  2)   GraphEditPlus 1.2
    GraphEditPlus will make each DirectShow developer's life much easier. Edit multiple graphs, see every bit of each mediatype, control your filters and generate C++ or C# code of a working application. DirectShow development was never so easy before!

  • Freeware .NET Obfuscator Skater Light  3)   Freeware .NET Obfuscator Skater Light 2.6.00
    Freeware .NET Obfuscator Skater Light Edition is an obfuscation tool for .NET code protection. It implements all known software protection techniques and obfuscation algorithms.

  • Active MediaMagnet  4)   Active MediaMagnet 5.6.5
    Active Media Magnet is the first software product that completely automates your press releases management and internet publicity strategy! Now submitting your press releases to over 33000 media contacts including newspapers, magazines, tv and more!

  • BrowserObject PHP Basic Edition  5)   BrowserObject PHP Basic Edition June.2008
    BrowserObject PHP module is best for developers who need to detect client's browser capabilities and settings. Unlike other detection technologies, BrowserObject PHP is using server side detection to detect client's browser information.

  • United States ZIP Code Database (Gold Edition)  7)   United States ZIP Code Database (Gold Edition) June.2008
    United States ZIP codes database subscription includes ZIP code, city name, alias name, state code, phone area code, city type, county name, FIPS, time zone, day light saving flag, latitude, longitude, elevation, MSA, PMSA and Census 2000 data.

  • United States ZIP Code Database (Premium Edition)  8)   United States ZIP Code Database (Premium Edition) June.2008
    United States ZIP codes database one month subscription service. The database includes ZIP code, city name, alias name, state code, area code, city type, county name, FIPS, time zone, day light saving flag, latitude, longitude and county elevation.

  • EQATEC Profiler  10)   EQATEC Profiler 1.1
    All other .NET CF profilers deal with memory profiling. This tool deals with profiling the execution of the code for locating performance bottlenecks. Free for all to use. Can profile any .NET 2.0/3.5 Compact Framework assembly (+ the full .NET too).


 
 
 

 
 
 
 
 
Main Menu
Home
Top Downloads
New Programs
Awards
Link To Us
Submit Programs
Bookmark
Contact Us


    Soft Categories

  ·  Active X
  ·  Basic & VB & VB DotNet
  ·  C & C++
  ·  Compilers & Interpreters
  ·  Components & Libraries
  ·  Database & SQL
  ·  Debugging
  ·  Editors & Tools
  ·  Help Tools
  ·  Install & Setup
  ·  Java & JavaScript
  ·  Others
  ·  PHP & ASP & HTML
  ·  Source Editors
  ·  XML
 

    Partners

Softs Land
Articles
Download Programs
Hotel Reservations
Gold Softs
Daily Articles
Driver Download
Search Engine Optimization
Cooks Recipes
Shareware Downloads
Spyware Info
Pimp MySpace
Programs DataBase
Mobile phone Details
Free Articles
Song Lyrics
 
 
Copyright @2006-@2008 DataPicks.com - Privacy Policy