|
|
|
|
|
RapidSQL comes with a paste SQL syntax
command. This will open a dialog where you can select any SQL command supported by
your DBMS. When you select one of these, it is displayed showing the generic syntax
for SQL statements or arguments for functions. This removes any need to go to the
online help to look up arguments or syntax since they are right at your fingertips.
There is also a SQL command builder which allows you to construct syntactically correct
SQL via point and click. This is a big productivity boost for those unfamiliar with
SQL.
The final feature is support for up to 9 independent workspaces. This gives you the ability to work with nine completely separate environments without ever leaving RapidSQL. I have used this when working on multiple projects simultaneously. Each project is contained in its own workspace where I can easily keep everything separated. RapidSQL is a very solid SQL development tool. While it doesn't contain every feature I would like to see in a development tool, it does come rather close. Three major features that I would like to see implemented in future releases are a full featured debugger, a solid reporting system, and either embedded version control or links to version control software. I use RapidSQL on a daily basis supplemented with SQL-Programmer to accomplish what I need to do in a timely fashion. The amount of time it saves me on each project would easily justify the purchase price of a few dozen copies. Accurately rewriting over 800 triggers within a two week time span would have been impossible without these two tools. RapidSQL is also extremely important to me in that it allows me to work disconnected from a network while still having access to almost all of the productivity features. I would definitely recommend RapidSQL for any SQL developer's tool kit. RapidSQL is produced by Embarcadero Technologies and can be purchased as part of an integrated tool suite which also contains ER/Studio for data modeling and DBArtisan for database administration. |
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.
