DatabaseSpy
| Altova DatabaseSpy | |
|---|---|
 with DatabaseSpy | |
| Developer(s) | Altova |
| Stable release | 2010r3
/ May 5, 2010 |
| Operating system | Microsoft Windows |
| Type | UML Tool |
| License | EULA |
| Website | http://www.altova.com/databasespy.html |
DatabaseSpy is a multi-database query, design, and database comparison tool from Altova, the creator of XMLSpy. DatabaseSpy connects to many major databases, facilitating SQL editing, database structure design, database content editing, database schema and content comparison, and database conversion.
DatabaseSpy is a database client application for Windows 7, Windows Vista, Windows XP, and Windows Server 2003 and 2008 that allows database administrators, database developers, and other database-oriented IT professionals to interact with multiple relational databases that may have been created by different developers.
Major features
DatabaseSpy includes these components:[1]
Quick connection wizard
Database project manager
Online database browser
Database content editor
SQL editor with SQL auto-completion
Graphical database design tool
Database table compare and merge tool
Database schema compare and merge tool with support for database structure conversion
Editor for views and stored procedures
Data export and import tool
DatabaseSpy also includes special support for XML in databases and is available in 32-bit and 64-bit versions.
Supported databases
DatabaseSpy connects to the following major database types:[2]
Microsoft® SQL Server® 2000, 2005, 2008
IBM DB2® 8, 9 (LUW)
IBM DB2 for iSeries® v5.4, 6.1
Oracle® 9i, 10g, 11g
Sybase® 12
MySQL® 4, 5
PostgreSQL 8
Microsoft Access™ 2003, 2007
DatabaseSpy can connect to multiple databases simultaneously, including databases of different types. DatabaseSpy automatically interprets variations in SQL dialects and data type definitions of different relational databases.
User comments
Licensing
DatabaseSpy is a licensed software product that uses key protection to prevent unlicensed usage. Altova offers customers an optional support and maintenance package, which allows them to upgrade to major new versions and maintenance releases. Service pack releases containing bug fixes are available to all users of the current software version. Altova updates its product line to add features and to ensure conformance with continually developing relational databases. All Altova products are free to try with a no-cost 30 day trial license.[3]