Lattice.SPGen Stored Procedure Generator 1.3 Free Download

   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



 
 
Download link
Size 235KB
License Shareware
Price 88
Category Programming & Software Development / Others
Operating System Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003
Buy Now Order full version
Developer Lattice Business Software Intl., Inc.

 
Top Others / Software Development programs
  • Free Serial Port Monitor  1)   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

  • Hexadecimal to ASCII Converter  2)   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..

  • ActiveComport Serial Port Toolkit  4)   ActiveComport Serial Port Toolkit 2.0
    Serial port toolkit to enable applications or scripts to communicate with a modem or other serial port device. Features full com port control, binary and ASCII data transfer, support for RS 232 and RS 485 standards and ISDN modem support.

  • EarthView  5)   EarthView 4.1.0
    EarthView is a dynamic desktop wallpaper and screen saver, which displays beautiful views of the earth with daylight and night shadows. It produces colorful, high quality, high resolution images for every screen resolution - even beyond 2560x1600!

  • ANPR  6)   ANPR 1. 0. 10. 5
    LPReditor, offers a robust, transportable, automatic license plate recognition (LPR) capability, designed exclusively for system integrators, value-added resellers, and volume end-users. LPReditor is built entirely on industry-standard modules

  • Docklight RS232 Terminal - RS232 Monitor  7)   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

  • ActiveGanttVB Scheduler Component  8)   ActiveGanttVB Scheduler Component 2.6.2
    Add Scheduling capabilities to your Application. This component makes it easy to build rosters, TV/movie scheduling, classroom scheduling, equipment/location rental, payroll, assembly line production, and many other applications.

  • VEDIT  9)   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

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


New Others / Software Development programs
  • UModel  1)   UModel 2013r2sp2
    Altova UModel 2013 Enterprise Edition is the starting point for successful software development. Visually design application models and generate code or reverse engineer programs to UML diagrams. It’s the simple, cost-effective way to draw on UML.

  • Exe Guarder  2)   Exe Guarder 4.1323
    With Exe Guarder you can converter normal exe-file to shareware. Once the executable is protected by exe guarder, you may copy it to another computer as it will stay protected. So you can publish it as shareware (also known as trialware or demowar

  • Avangardo GPS generator PRO  3)   Avangardo GPS generator PRO 4.1.5
    The GPS Generator PRO application is designed for providing assitance in developing, testing and debugging programs and equipment working with the NMEA-0183 protocol. This application can also be used for learning and testing navigation applications.

  • Basic Toolbar Icons  4)   Basic Toolbar Icons 2013.1
    If you need a great-looking set of toolbar icons for your brand-new of redesigned application, make sure to try Basic Toolbar Icons! It is a set of pro-level and high-quality interface icons that will suit any modern business application.

  • EarthView  6)   EarthView 4.1.0
    EarthView is a dynamic desktop wallpaper and screen saver, which displays beautiful views of the earth with daylight and night shadows. It produces colorful, high quality, high resolution images for every screen resolution - even beyond 2560x1600!

  • Apex SQL Log  7)   Apex SQL Log 2011.03
    ApexSQL Log is a transaction log reading tool that shows you the changes made to your database. It decodes SQL Server's transaction log into a readable format exposing information such as what change was made, when it was made, and by whom.

  • Apex SQL Edit  8)   Apex SQL Edit 2011.02
    Apex SQL edit is an integrated SQL database editing tool/IDE. Apex SQL Edit provides source control integration with Visual Source Safe, Vault, Microsoft Team System and a variety of other SCC-compliant source control systems.

  • Apex SQL Doc  9)   Apex SQL Doc 2012.01
    Apex SQL Doc is a powerful tool to document your sql server database into CHM, Linked HTML, HXS, Doc and Docx help Documentation.

  • Apex SQL Diff  10)   Apex SQL Diff 2012.01
    ApexSQL Diff 2012 is a high speed Database comparison and synchronization tool. Automatically generate scripts to synchronize two databases, graphically view object script differences, run unattended via the command line or programmable API.

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

    Soft Categories

  Audio & Mp3
  Business & Finance
  Desktop Enhancements
  Games
  Home & Education
  Internet
  Multimedia & Design
  Security & Privacy
  Software Development
      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
  System Utilities
  Web Development
 

Related tags:
stored procedure
stored procedure generator
stored procedure builder
stored procedure creator
stored procedure wizard

(C) 2006-2008 AlienPicks.com - All Rights Reserved - Privacy Policy