Product Reviews

Catch-All IDE

dbPal Universal attempts total drag-and-drop development.

It's a wee bit hard to know how to describe dbPal universal, but let's try this: it's a drag-and-drop, multi-user, Internet-enabled, universal scripting, debugging, and development environment for database designers. Whew, what a mouthful.

The basic idea is that dbPal can extract a schema from any supported database: Access, SQL Server, FoxPro, Oracle, DB2, MySQL...and on and on. The schema then is stored in an abstract, univesal format by dbPal, and you can work with it, renaming objects, creating new objects, whatever. The product then knows how to apply these changes back to a database. It can also do a variety of other interesting things, like applying changes from one database to another, or extracting a schema from a SQL Server database and creating a corresponding Oracle database. There's a lot of "smarts" built into the program to handle things like the naming limiitations of the target products.

dbPal Universal is the high end of their product line. Features here include complete version control, a scripting language with timed execution, and multiuser support. It's easy to see how dbPal could become the backbone of an entire dba organization.

This power comes at the cost of a bit of a learning curve. The dbPal interface is relentlessly drag-and-drop, and has a whole bunch of help built into it, so it's not that hard to learn. But it is unlike anything else you've ever used. This is one of those programs that you'll need to work with on a fairly steady basis to keep your skills up.

If you'd like to have a look, you can download a trial version from the company's database. There you can also pick up the lower-end versions of the application, which are targeted to single users or single database types. These can provide a more cost-effective introduction to the dbPal way of working while you're deciding whether to go whole hog with the product.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.


  • Cloud Services Use on the Rise But Security Concerns Remain

    A recently published industry report suggested that use of public cloud services by organizations may nearly double in the next two years.

  • OneDrive Users To Get Storage Options, Plus New Personal Vault

    Microsoft announced a few OneDrive enhancements, including storage-option additions, plus a new "Personal Vault" feature for added security assurance.

  • Cloud Services Starting To Overtake On-Prem Database Management Systems

    Database management system (DBMS) growth is happening more on the cloud services side than on the traditional "on-premises" side, according to a report by Gartner Inc.

  • How To Replace an Aging Domain Controller

    If the hardware behind your domain controllers has become outdated, here's a step-by-step guide to performing a hardware refresh.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.