DatabaseSpy

Altova DatabaseSpy

SQL editor with results view and graphical design editor in DatabaseSpy
Developer(s) Altova
Stable release 2013r2sp1 / June 12, 2013
Operating system Microsoft Windows
Type Relational database 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 relational databases, 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.[1]

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:[2]

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.[3][4][5]

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.[6]

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.”[7]

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.[8]

Licensing

DatabaseSpy is a licensed software product that uses key protection to prevent unlicensed usage. DatabaseSpy is free to try with a no-cost 30 day trial license.[9]

See also

References

  1. ↑ Altova website
  2. ↑ Altova website
  3. ↑ Infoworld, April 9, 2007
  4. ↑ MSDN Magazine, October 2007
  5. ↑ Redmond Magazine: Tooling Around Your Database, August 1, 2008
  6. ↑ SQL Server Magazine, April 26, 2010
  7. ↑ Software Review: Database Comparison and Merging From Altova, May 19, 2009
  8. ↑ 2009 SQL Server Magazine Editors' Best and Community Choice Awards
  9. ↑ Altova website

External links

This article is issued from Wikipedia - version of the Monday, February 15, 2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.