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.

Featured

  • Azure Active Directory ID Protection 'Refresh' Now Available

    Microsoft's enhancements to the Azure Active Directory Identity Protection service are now said to be "generally available" (GA), or ready for commercial use, per a Wednesday announcement.

  • Microsoft Releases Windows 10 Version 1909

    Microsoft on Tuesday announced the release of Windows 10 version 1909, a new operating system product that's also known as the "Windows 10 November 2019 Update."

  • November Microsoft Security Bundle Addresses 75 Vulnerabilities

    Of that number, 13 vulnerabilities are rated "Critical" to patch, while 62 vulnerabilities are deemed "Important."

  • The Future of Office 365 Pricing

    With a raft of new Office 365 features in the pipeline, Microsoft also seems ready to change the way it bills its subscribers. Will it replicate Azure's pay-per-use model, or will it look like something else entirely?

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.