DatabaseSpy
   HOME

TheInfoList



OR:

DatabaseSpy is a multi-database query, design, and database comparison tool from Altova, the creator of XMLSpy. DatabaseSpy connects to many major
relational database A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured for ...
s, facilitating SQL querying, 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 Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...
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 data. It defines a set of rules for encoding electronic document, documents in a format that is both human-readable and Machine-r ...
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 proprietary relational database management system developed by Microsoft using Structured Query Language (SQL, often pronounced "sequel"). As a database server, it is a software product with the primary function of ...
*
PostgreSQL PostgreSQL ( ) also known as Postgres, is a free and open-source software, free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transaction processing, transactions ...
*
Oracle An oracle is a person or thing considered to provide insight, wise counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. If done through occultic means, it is a form of divination. Descript ...
*
MySQL MySQL () is an Open-source software, 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 rel ...
* IBM Db2 * IBM Db2 for i * Informix * Sybase ASE *
Microsoft Access Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational database, relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsof ...
* MicroSoft Azure SQL * MariaDB *
SQLite SQLite ( "S-Q-L-ite", "sequel-ite") is a free and open-source relational 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 ...
* Firebird *
Progress Progress is movement towards a perceived refined, improved, or otherwise desired state. It is central to the philosophy of progressivism, which interprets progress as the set of advancements in technology, science, and social organization effic ...
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.


See also

*
Comparison of database tools The following tables compare general and technical information for a number of available database administration tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to dat ...


References


External links


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