DatabaseSpy
Encyclopedia
DatabaseSpy is a multi-database query, design, and database comparison tool
from Altova
, the creator of XMLSpy
. DatabaseSpy connects to many major relational database
s, facilitating SQL querying, database structure design, database content editing, and database comparison and 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.
DatabaseSpy features include a quick connection wizard for multiple relational databases, SQL
editor with auto-completion, graphical database design tool, database content and schema comparison, and data import and export in multiple formats. DatabaseSpy also includes special support for XML
in databases and is available in 32-bit and 64-bit versions.
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
The use of a common graphical interface to connect to multiple databases, even on different platforms, is cited as a valuable feature. "For developers and power users, this offers a great way to tame some of the complexity that they might need to deal with in a heterogeneous environment," wrote one user.
The DatabaseSpy comparison functionality has also been highlighted. “ … its ability to let you compare and merge the contents of database tables via its graphical representation … is especially handy when you are moving from one system to another.”
DatabaseSpy won a 2009 SQL Server Magazine
Editors' Best and Community Choice Award. "If you’re managing more than one flavor of database, you’ll want to check out this multipurpose toolset,” said one editor.
Comparison of database tools
The following tables compare general and technical information for a number of available database administrator tools. Please see individual product articles for further information...
from Altova
Altova
Founded in 1992, Altova is a commercial software development company with headquarters in Beverly, MA, USA and Vienna, Austria that produces integrated XML, database, UML, and data management software development tools.-Products:Altova’s products include:...
, the creator of XMLSpy
XMLSpy
XMLSpy is an XML editor and integrated development environment from Altova. XMLSpy allows developers to create XML-based and Web services applications using technologies such as XML, XML Schema, XSLT, XPath, XQuery, WSDL, and SOAP...
. DatabaseSpy connects to many major relational database
Relational database
A relational database is a database that conforms to relational model theory. The software used in a relational database is called a relational database management system . Colloquial use of the term "relational database" may refer to the RDBMS software, or the relational database itself...
s, facilitating SQL querying, database structure design, database content editing, and database comparison and 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.
DatabaseSpy features include a quick connection wizard for multiple relational databases, SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
editor with auto-completion, graphical database design tool, database content and schema comparison, and data import and export in multiple formats. DatabaseSpy also includes special support for XML
XML
Extensible Markup Language is a set of rules for encoding documents in machine-readable form. It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards....
in databases and is available in 32-bit and 64-bit versions.
Supported databases
DatabaseSpy can connect to multiple databases simultaneously, including databases of different types. DatabaseSpy automatically adjusts to variations in SQL dialects and data type definitions of supported relational databases. DatabaseSpy connects to the following major database types: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
User comments
From its initial release in September 2006, users have recognized the benefits of using a single tool with a consistent user interface to multiple databases to perform routine tasks such as querying or modifying tables.The use of a common graphical interface to connect to multiple databases, even on different platforms, is cited as a valuable feature. "For developers and power users, this offers a great way to tame some of the complexity that they might need to deal with in a heterogeneous environment," wrote one user.
The DatabaseSpy comparison functionality has also been highlighted. “ … its ability to let you compare and merge the contents of database tables via its graphical representation … is especially handy when you are moving from one system to another.”
DatabaseSpy won a 2009 SQL Server Magazine
SQL Server (magazine)
SQL Server is a trade publication and web site owned by Penton Media serving the information needs of IT Professionals in various fields including data processing, computer related consulting and many other areas....
Editors' Best and Community Choice Award. "If you’re managing more than one flavor of database, you’ll want to check out this multipurpose toolset,” said one editor.