Altova DatabaseSpy is the unique multi-database tool from the creators of XMLSpy and MapForce. It connects to all major databases and eases SQL editing, database design, and other tasks much more affordably than single-database solutions.
Version: 2020sp1Altova DatabaseSpy Enterprise Edition is the unique multi-database query, design, and conversion tool from the creators of XMLSpy.
License: Free To Try $189.00
Operating System: Windows
DatabaseSpy connects to all major databases, easing SQL editing and other database tasks for a fraction of the cost of single-database solutions. DatabaseSpy provides a straightforward database connection wizard and organizes connections and related project files to make accessing your databases and their components effortless.
You can open connections to multiple databases at once, even databases of different types. It clearly presents tables, views, stored procedures, and data in convenient windows, and lets you directly edit database content.
DatabaseSpys SQL Editor facilitates query writing with code completion, syntax coloring, drag & drop editing, and more. You can retrieve data from multiple tables and display results in individual, named windows for maximum clarity.
DatabaseSpy generates customized business intelligence charts from query results in your choice of line, bar, pie, area, gauge, or candlestick styles. DatabaseSpys powerful Design Editor enables graphical design and visualization of database structures or schemas.
XML support includes advanced capabilities to inspect XML data in tables and to manage the XML Schemas used to validate that data. It exports data in five formats and imports data from CSV and XML files.
DatabaseSpy connects to Microsoft SQL Server, PostgreSQL, Oracle, MySQL, IBM DB2, Informix, Sybase, Firebird, MySQL, SQLite, MariaDB, Teradata Microsoft Access, and more. With all this capability and more, DatabaseSpy is sure to save you time, simplify your work, and ensure accuracy for all your data. DatabaseSpy is available in 32-bit and 64-bit versions.
Version 2020sp1: Bug fixes and other enhancements
Version 2018: Support for SQL templates, Support for foreign key enforcement in SQLite, bug fixes, and other enhancements