Altova DataBaseSpy Enterprise Edition Releases

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...

Released: Dec 3, 2019

Updates in 2020 SP1

Fixes

  • DatabaseSpy no longer recognizes ”max” length for SQL Server nvarchar columns.

Released: Oct 9, 2019

Updates in 2020

Features

  • Export to Microsoft Excel - DatabaseSpy makes it easy to export database data to formats such as XML, CSV, HTML, and now Excel. You can export data either directly from specific tables or views, or via SQL SELECT statements. At the table level, you can choose which columns should be exported, as well as whether or not to include column headers. Export is compatible with Excel versions 2007 and later (.xslx).
  • Support for additional database versions - DatabaseSpy and all database-enabled...

Released: Apr 2, 2019

Updates in 2019 Release 3

Features

  • Conditional formatting of rows in Results Window - When you run SELECT statements in the DatabaseSpy SQL Editor, the retrieved data is displayed in the Results window. Starting with DatabaseSpy 2019r3, you can customize the appearance of the retrieved data (such as specifying a background color, font color, bold, italic, etc.) based on custom SQL conditions. For example, you can have certain values in the Result grid formatted with a yellow background if they exceed some threshold. The...

Released: Oct 17, 2018

Updates in 2019

Features

DatabaseSpy supports the latest version of the following databases:

  • Firebird 3
  • Informix 12.10
  • MariaDb 10.3
  • Microsoft SQL Server 2017
  • MySQL 8
  • PostgreSQL 10
  • In addition, SQL Server now runs on Linux, and DatabaseSpy can connect to that as well.