Altova DatabaseSpy 2023 Enterprise Edition2023.02.00

Altova DatabaseSpy 2023 Enterprise Edition lets users connect to major database systems, browse their structures, edit stored content, write SQL, and convert databases from one working environment. A quick-connect wizard helps establish connections, while the database browser provides an organized view of tables and other database objects. Its graphical database design tool supports visual planning and modification of database structures instead of limiting work to text-based SQL.

The SQL Editor separates a statement area from one or more tabbed or stacked result windows, so users can execute commands and inspect output immediately. Syntax coloring distinguishes statements, parameters, operators, and comments, and customizable auto-completion assists with query construction. SQL Templates let users replace fixed values with parameters, making queries such as multi-condition order searches easier to reuse and test. Queries can run asynchronously in separate windows, including simultaneous work against different servers or multiple queries on one server. Formatting rules are supplied for each supported database and applied automatically when switching databases, including IBM DB2 for iSeries, Microsoft Azure SQL, and Microsoft SQL Server.

Users can turn SQL query results into charts for visual analysis alongside the raw data, making DatabaseSpy useful to database developers, administrators, and analysts handling several database technologies. The Windows System Tools release is published by Altova as version 2023.02.00 for x64 systems, and is intended for situations that combine SQL investigation, schema design, data editing, and database conversion in one application.