Altova DatabaseSpy 2023 Professional Edition2023.02.00

Use Altova DatabaseSpy 2023 Professional Edition to connect to multiple databases, write SQL, inspect returned data, and work on database structures from one Windows application. It combines querying and database design, allowing developers and database professionals to examine information and structure work in the same environment. This x64 Windows release is version 2023.02.00 from Altova.

A quick-connect wizard and database browser assist with connecting to databases and navigating their contents, while data-editing features allow stored information to be changed. Its graphical database design tool supports work on database structures, and database conversion functions support conversion between databases. Query results can be turned directly into charts, providing a visual view alongside the returned data.

The SQL Editor divides work between a SQL statement window and one or more tabbed or stacked result windows, with an Execute command for running statements and viewing output. Color coding distinguishes SQL statements, parameters, operators, and comments, while customizable auto-completion helps construct queries. Formatting configurations are provided for each supported database and applied when the active database changes. Asynchronous execution allows queries in separate windows to run at the same time, including multiple queries against one server.

SQL Templates let users replace fixed values with parameters, making queries reusable for tasks such as testing joins with different inputs. DatabaseSpy supports all major databases, including IBM DB2 for iSeries, Microsoft Azure SQL, and Microsoft SQL Server, and suits people who need shared tools for querying, content editing, structure design, and conversion.