Database administrators (DBAs) usually find it excessively troublesome when it comes to dealing with multiple databases simultaneously. From managing and designing data to comparing it, DBAs pour their huge amount of time in handling various databases together. Nonetheless, in order to perform these tasks effectively they often keep searching a competent database processing utility. If you’re also hopping through several websites to find such a tool, then Altova DatabaseSpy 2009 application can be an appropriate assistant for you. The program allows working with multiple databases, and supports connecting to entire major databases. Using the program, it gets easier to design database structure and edit SQL without getting your pockets burdened. Further, the utility compatibly functions with MS SQL Server 2000/2005/2008 along with IBM DB2 8/9, IBM DB2 for iSeries v5.4, Oracle 9i/10g/11g, Sybase 12, MySQL 4/5, PostgreSQL 8, and MS Access 2003/2007.

The Altova DatabaseSpy 2009 software offers an intuitive database connection wizard and supports organizing database connections and project files effectively. Moving towards the main console, it’s been designed to provide different functions available for usage instantly, as various features have been set all over it. Connecting the database, you can explore its tables, constraints, indexes, view, XML schemas, procedures, etc, with the navigation panel placed on console’s left. The data contained in selected table or other components can be easily edited on the right side workspace. You can select different databases to easily compare and merge tables, whether they’re from same database or not. It also supports writing SQL scripts, and SQL query with syntax coloring to find the necessary data from the entire database. Further, you can also filter tables, inspect XML data, manage XML schemas, and import data from CSV or XML files, if required. With its exclusive feature-set its lets you explore the project, properties, over view, online browser, database structure, etc. Not just these, it offers several other tools and settings in order to explore, manage and query databases.

The utility includes impressive and comprehensive range of features and prompt functionality that helps saving huge time of DBAs, considering which it’s found worthy to be rated with 4.5 rating points.