Altova DataBaseSpy Enterprise Edition Releases

Released: Oct 24, 2023

Updates in 2024

Features

  • AI Assistant - This release includes two ways to utilize new, built-in AI functionality:
    • AI Chat Dialog - The AI Chat Dialog allows you to send requests to ChatGPT to create sample SQL statements, create sample data for a given table structure, create relations between tables that have no keys yet, and so on. Once you send a request and receive the response, you can copy and paste the returned SQL into an existing file or create a new SQL file with the response.
    • AI Extensions - In...

Released: Apr 12, 2023

Updates in 2023 Release 2

Features

  • Support for additional database versions - Database support has been updated to include the latest versions of the following databases:
    • Firebird 4.
    • PostgreSQL 15.
    • Microsoft SQL Server 2022.

Released: Dec 12, 2022

Updates in 2023 SP1

Fixes

Import

  • CSV import containing many columns wraps headers to the line below.

Released: Oct 19, 2022

Updates in 2023

Features

  • Support for additional database versions - DatabaseSpy 2023 supports the newest versions of multiple databases:
    • MariaDB 10.9.2.
    • PostgreSQL 14.5.
    • SQLite 3.39.2.

Released: Mar 8, 2022

Updates in 2022 Release 2

Features

  • Added support for additional database versions - This release supports the newest versions of several databases:
    • IBM DB2 11.5.7.
    • MySQL 8.0.28.
    • MariaDB 10.6.5.
    • SQLite 3.37.
    • PostgreSQL 14.1.

Released: Oct 27, 2021

Updates in 2022

Features

  • Support for Microsoft Windows 11 - DatabaseSpy now supports running on Windows 11.
  • Support for additional database versions - DatabaseSpy now supports the latest versions of the following databases in addition to previous versions:
    • IBM DB2 11.5.
    • MySQL 8.0.25.
    • PostgreSQL 13.
    • SQLite 3.35.5.

Released: Jun 1, 2021

Updates in 2021 Release 3

Fixes

  • Bug fixes and other improvements.

Released: Mar 4, 2021

Updates in 2021 Release 2

Features

  • Undo support for projects - You can now instantly undo changes made to a project to easily fix a mistake.
  • Added the ability to generate DDL scripts at the catalog level.
  • Sorting results are no longer case-sensitive.
  • Updated support for IBM DB2 iSeries - Support for IBM DB2 iSeries has been updated to 7.4.

Released: Oct 14, 2020

Updates in 2021

Features

  • Added option to show multiple database root objects - Many database types support multiple root objects, and these can now be shown in the DatabaseSpy Online Browser pane where current database connections are visualized.
  • Added option to stop SQL execution at specific command(s) - By default, SQL scripts run through even if an error occurs with a SQL command, which can be problematic when SQL scripts contain multiple statements. Now, in addition to the option to halt SQL execution as...

Released: Mar 17, 2020

Updates in 2020 Release 2

Features

  • SQL execution summary - DatabaseSpy now provides an execution summary that is particularly useful when executing a lengthy SQL script with numerous statements. The summary lists the number of successful statements and the number of errors reported by the database, if any, so that they can be addressed immediately.
  • Additional options for result row formatting - For quick analysis, the DatabaseSpy SQL editor lets users define conditional formatting of query results displayed in the...