DatabaseSpy is a multi-database query, design, and database comparison tool from

Altova Altova is a commercial software development company with headquarters in Beverly, MA, United States and Vienna, Austria that produces integrated XML, JSON, database, UML, and data management software development tools. Company Altova was founded ...

, the creator of

XMLSpy XMLSpy is a proprietary XML editor and integrated development environment (IDE) developed by Altova. XMLSpy allows developers to create XML-based and Web services applications using technologies such as XML, JSON, XBRL, XML Schema, XSLT, XPath ...

. DatabaseSpy connects to many major

relational database A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relatio ...

s, facilitating

SQL query The SQL SELECT statement returns a result set of records, from one or more tables. A SELECT statement retrieves zero or more rows from one or more database tables or database views. In most applications, SELECT is the most commonly used data man ...

ing, database structure design, database content editing, and database comparison and conversion. DatabaseSpy is a database client application for Windows 7, 8, and 10, 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 Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing arbitrary data. It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. T ...

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 Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which ma ...

PostgreSQL PostgreSQL (, ), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the In ...

Oracle An oracle is a person or agency considered to provide wise and insightful counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. As such, it is a form of divination. Description The word '' ...

MySQL MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database o ...

IBM Db2 Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON a ...

* IBM Db2 for i * Informix * Sybase ASE *

Microsoft Access Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools (not to be confused with the old Microsoft Access w ...

* MicroSoft Azure SQL * MariaDB *

SQLite SQLite (, ) is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the most ...

Firebird Firebird and fire bird may refer to: Mythical birds * Phoenix (mythology), sacred firebird found in the mythologies of many cultures * Bennu, Egyptian firebird * Huma bird, Persian firebird * Firebird (Slavic folklore) Bird species ''Various spe ...

* Progress OpenEdge * Teradata * And others

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, possibly across different platforms, is cited as a valuable feature.

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.

References

External links

Altova website
{{DEFAULTSORT:Databasespy Database administration tools PL/SQL editors Sybase

Supported databases

User comments

Licensing

See also

References

External links