Search
  Home
  Articles
  Backup
  Books
  Certification
  FAQ
  Products
  Replication
  Scripts
  Seminars
  Training
  TSQL

MSDN Fourms
Philippine SSUG

  Resume

MHS Enterprises
FilAm Software
AcrylicAcetate.com
Bargain Humidors
Western Humidor



RapidSQL 4.1 1 2 3 4 5

Note: There are a number of screen shots included in this article. While they may take a moment to load, they are important in the evaluation of this highly graphical product.

RapidSQL is a tool devoted to SQL development.  There are some extremely nice productivity features in here and this version is a major step ahead in performance, scalability, and stability.  I would definitely recommend purchasing this one also.  I'm glad that I don't have to make a choice between SQL-Programmer and RapidSQL.   Both products do an extremely good job.  Since I have copies of both products, I actually use them side by side, however, I prefer RapidSQL to do most of my actual coding.  (This is more of an environmental thing and the fact I work disconnected almost 70% of the time right now.)  If I had to pick the perfect SQL development tool, it would actually be a combination of both products.  For those who do all of their work on site, I think it is a toss up at this point.  For those who do remote work, RapidSQL is the only product for you.  If it is in your budget, I would actually purchase both of them to take advantage of the strengths and features present in both products.

RapidSQL provides a significant productivity boost with a variety of features.  It has integrated e-mail support for any MAPI compliant e-mail system, color coded syntax which can be a real lifesaver, split screen error reporting and double click navigation to an error, browser windows, favorites list where you can store frequently used scripts and script fragments for drag and drop inclusion, a SQL syntax builder, query builder, multiple workspaces, bookmarks within scripts for easy navigation, and my favorite a search window.

The environment that I tortured RapidSQL in was my current client.   I reviewed and rewrote over 800 triggers and am now just starting to look at the 300+ stored procedures.  As such, I routinely extract numerous scripts and work on them in batches.  Granted, not many companies make software to match the way I work.   (Having multiple instances of 5 or 6 tools open and running processes at any given time is routine for me.  I also will generally open 100+ scripts to work with at a time when I'm doing this type of work.)  This is where the scalability really shines in the 4.1 version.

RapidSQL has a very nice browser feature for each type of object in your database.  Bringing up a browser window is a simple click away and you get a nice grid with enough basic information in it. 

Rapid01.gif (40020 bytes)

Simply highlighting and selecting extract will place the DDL for each object into its own window.  The extraction is quick and efficient.  With 4.1 I succeeded in opening almost 500 objects recently before getting a running low on resources message.  (As long as they fixed the previous problems, I thought I'd see how far it would go.)  It plowed along very quickly extracting DDL and only started to show a noticeable decrease in performance at about the 350 object range.  Version 4.1 has also been very stable.  RapidSQL has been running on my machine 24 hours per day for more than two weeks now without ever having a crash.

Rapid02.gif (30042 bytes)

RapidSQL 4.1 1 2 3 4 5

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.