Multi-Database Tool and SQL Editor
Altova DatabaseSpy is the unique multi-database query, design, and database comparison
tool that even generates elegant charts directly from query results.DatabaseSpy connects
to all major databases, easing SQL editing, database structure design, content editing,
database schema and content comparison, and database conversion for a fraction of the cost
of single-database solutions.
SQL Editor and Query Tool
The versatile DatabaseSpy SQL Editor is divided into a SQL statement window and one or
more tabbed or stacked Result windows, with a convenient Execute button in the SQL Editor toolbar
to let you immediately execute your SQL statements and view the output.The SQL statement window
applies color coding to each SQL statement with unique identification for SQL statements, parameters,
operators, and comments to help you quickly and easily review and analyze an individual SQL query or
a complex series of SQL commands.
The DatabaseSpy SQL editor features customizable SQL auto-completion to accelerate SQL query
development. Execute queries and see immediate results in one or more windows that may be tabbed or stacked.
- Firebird 2.5, 3
- IBM DB2 for iSeries® v6.1, 7.1, 7.2, 7.3
- IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
- Informix® 11.70, 12.10
- MariaDB 10, 10.3
- Microsoft Access™ 2003, 2007, 2010, 2013
- Microsoft® Azure SQL
- Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016, 2017
- MySQL® 5, 5.1, 5.5, 5.6, 5.7, 8
- Oracle® 9i, 10g, 11g, 12c
- PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4, 9.6, 10, 11
- Progress OpenEdge 11.6
- SQLite 3.x
- Sybase® ASE 15, 16
- Teradata 16
SQL formatting configurations are provided for each supported database and appropriate
formatting is automatically applied when you switch databases. DatabaseSpy supports
asynchronous query execution, allowing multiple SQL queries to be processed in different
windows at the same time, either queries to different servers or even multiple queries
against the same server.
Support for SQL Templates
DatabaseSpy includes support for SQL queries that contain parameters, also known as SQL
Templates. Parameters can make a query much more flexible, for instance allowing users to
easily test complex join statements with multiple values.
The DatabaseSpy SQL Editor and result windows at the top left below show a query to report
all orders of a specific product by a specific customer.
This query could be much more flexible by replacing the product name ‘sprockets’ and the
customer number 525 with parameters, as shown in the second query window above where
the parameters :pname and :custnum are substituted for the product and customer.