Product Review: Accelerate SQL Stored Procedures Generation using e Tek Global's SQL SP Generator
page 1 of 15
Published: 14 Sep 2007
I am an experienced DBA and I will be reviewing the e Tek Global's SQL SP Generator tool. I have been using it for last couple of weeks and it is a very handy tool to have. I was also involved in the beta testing. It is integrated with SQL Server 2005 and allows users to create Stored Procedures, alias columns/tables and also setup SQL Server security for users. Compared to quite a few products that I have used with the same capability, this is the tool that I would recommend.
by Leonard Mwangi
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 40708/ 60


At my current job we depend a lot on stored procedures for our web applications and sometimes it gets really boring when we have to write and re-write stored procedures for different databases and tables as demands increase. This pain has me looking for an easier and faster way to generate standard stored procedures that would meet our database design specifications. A few years back I stumbled on some source code developed by e Tek Global that would create stored procedures, but there were some short comings with the brilliant tool because I had to know and pass my parameters to make the procedures usable since it did not have a front end GUI. With my hunger then to still make my job easier I went Googling and bought a tool with a GUI but it still it had its own issues.

A few days ago I received an email from e Tek Global regarding a new SQL 2005 add-in tool to do a similar job as the one they had developed previously. With the descriptions it looked attractive but I was not sure if it would be good enough to replace what I had. I decided to give it a try with the evaluation copy. I was amazed by what the tool could do despite some features not being function on the evaluation copy. I was still able to generate powerful, well designed stored procedures. So here I am giving you a sneak peek into SQL SP Generator.


View Entire Article

User Comments

Title: Good Tool   
Name: NW
Date: 2007-09-17 10:51:17 AM
This tool is awesome. Thanks for sharing the info.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-04-14 12:12:09 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search