Altova DatabaseSpy 2024 Enterprise Edition2024.02.01

Run SQL queries against connected databases and inspect the returned data in Altova DatabaseSpy 2024 Enterprise Edition, while handling database-design tasks in the same Windows program. Its multi-database workflow suits projects that move between different database environments instead of confining SQL work to one engine. Results can be converted into charts, allowing query output to be examined visually as well as in tables.

A quick-connect wizard establishes connections to all major databases, and the database browser provides a navigable view of their structures. The SQL editor offers customizable auto-completion, color-coded statements, and an Execute control that sends commands for immediate output. Its workspace separates the SQL statement area from one or more tabbed or stacked result windows, keeping several result views available.

Color coding distinguishes individual SQL statements, parameters, operators, and comments, helping users review both single queries and long command sequences. Formatting rules are supplied for each supported database and applied automatically when the active database changes; supported examples include IBM DB2 for iSeries, Microsoft Azure SQL, and Microsoft SQL Server. Asynchronous execution lets queries run in separate windows at the same time, including queries sent to different servers or multiple queries sent to one server.

SQL Templates let users parameterize queries, making tasks such as testing a complex join with different values easier to repeat. DatabaseSpy also provides graphical database design, content editing, and database conversion, making it useful to database developers, administrators, and designers handling structure and data changes. Published by Altova as a System Tools product for x64 Windows, version 2024.02.01 is positioned as an affordable workspace for multi-database SQL and design work.