When discussions of the enterprise-data explosion get under way, the focus tends toward topics such as how to manage large amounts of data, how to keep it secure, and how to make it highly available. One subject that often gets overlooked is how the data deluge has affected the everyday work habits of the non-IT worker, or even the non-DBA: It's forcing ordinary end-users to get up to speed on the complexities of DBs and working with data.

TEST CENTER DAILY BLOG Track the latest product reviews and news from the InfoWorld Test Center.

The Bottom Line Altova DatabaseSpy 2007 Altova, http://altova.com Very Good  8.3 criteria score weight Ease-of-use 8 25% Manageability 8 25% Performance 9 15% Reliability 8 15% Setup 9 10% Value 8 10% Cost: $129 per user Platforms: Client: Windows NT/2000/XP; databases: SQL Server 2000 and 2005, Access 2003, Oracle 9i and 10g, IBM DB2 8.x and 9, MySQL 4.x and 5.x, and Sybase 11 Bottom Line: DatabaseSpy 2007 is a very nice query tool that works with multiple databases in a single project. It has intuitive and powerful import/export facilities that handle an array of file types. It also has a base-level table designer that works very well for the non-database professional. Users will love the code-completion feature. And, although Vista is not officially listed as a supported platform, I had no problems running DatabaseSpy on the OS. About our Reviews and Scoring Methodology

Altova's DatabaseSpy 2007 does a pretty good job of lowering the learning curve for a lot of common database tasks so that employees can concentrate on their jobs instead of becoming DBAs. All in all, it's quite a nice tool that's quick and easy to set up and use. Although it lacks some administrative functionality that would be attractive to admins, it still boasts some surprisingly rich features, such as IntelliSense code-completion. It's safe to predict that Altova has some pretty big plans in store.

For my tests, I started off by installing DatabaseSpy on my new Vista machine. The setup was very easy with few choices to make. Most anyone should have no trouble at all getting DatabaseSpy running.

DatabaseSpy's editing features were the most impressive of the product's capabilities. For starters, there's the very nice IntelliSense code-completion feature that beats SQL Server Management Studio's hands down. (Oh that's right: SSMS doesn't have IntelliSense.) IntelliSense not only fills in table names and other objects as you type, but it also gives you reserved words. Notably, the features work only for SQL Server, although DatabaseSpy works with all databases.

Surprisingly, the IntelliSense gives you all of the DBCCs (database console commands), the internal procedures DBAs use to perform much of their admin functions such as re-indexing. This is pretty advanced functionality for what essentially equates to an end-user tool. If you ask me, it's proof positive that Altova has much bigger plans for this product.

Another really nice feature is the Favorites section in the tree view. By adding any objects in a project to your Favorites list, you no longer have to keep searching through hundreds of objects to find it; rather, you'll have easy access to it whenever you like. This, too, is lacking in competitors' native tools.

Click for larger view.

Other nice coding features are the ability to define named code regions, and to send query results to named result panes. Named code regions allow you to specify a section of code that you can collapse, making long code routines easier to sift through. Named result panes are tabbed query result windows that you can name in order to keep different result sets straight. It can be very handy.

DatabaseSpy also has very useful import/export functionality. It allows you to import data quite easily from flat files and export it to a number of destinations, including CSV, XLS, HTML, XML, XML Structure, and -- that's right, you guessed it -- directly to XMLSpy, the company's XML editing/modeling tool. (I love it when tools work well with one another, especially when they're from the same company.)

I tested the export functions on a number of files with different configurations, and the wizard proved extremely quick and easy to use. The import was excellent as well: easy to use, and it performed far better than I would have hoped.