Altova DatabaseSpy

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.

Altova DatabaseSpy 2010 is the unique multi-database data management, query, design, compare, and convert tool from the creators of XMLSpy. DatabaseSpy connects to all major databases, easing SQL editing and other database tasks for a fraction of the cost of single-database solutions. DatabaseSpy provides a straightforward database connection wizard and organizes connections and related project files to make accessing your databases and their components effortless. You can open connections to multiple databases at once, even databases of different types. It clearly presents tables, views, stored procedures, and data in convenient windows, and it also lets you directly edit database content. DatabaseSpy's SQL Editor facilitates query writing with code completion, syntax coloring, drag ' drop editing, and more. You can easily write SQL scripts that retrieve data from multiple tables, and display results in individual, named windows for maximum clarity. DatabaseSpy's powerful Design Editor enables graphical design and visualization of database structures or schemas. You can also use it to compare and convert existing structures in the same or differing database types. DatabaseSpy supports Microsoft SQL Server, IBM DB2, Oracle, Sybase, MySQL, PostgreSQL, and Microsoft Access. DatabaseSpy lets you compare and merge the contents of database tables, whether they are the same database type or equivalent tables in different databases. XML support includes advanced capabilities to inspect XML data in database tables and to manage the XML Schemas used to validate that data. It exports data in five formats, including XML, XML Structure, CSV, HTML, and Excel, and imports data from CSV and XML files. Easily load binary data from an external file, or save binary data from the database. With all this capability and more, DatabaseSpy is sure to save you time, simplify your work, and ensure accuracy for all your data. DatabaseSpy is available in 32-bit and 64-bit versions.