Released: Oct 27, 2021

2022 での更新項目

機能

• 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

2021 Release 3 での更新項目

不具合の修正

• Bug fixes and other improvements.

Released: Mar 4, 2021

2021 Release 2 での更新項目

機能

• 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

2021 での更新項目

機能

• 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 soon as...

Released: Mar 17, 2020

2020 Release 2 での更新項目

機能

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

Released: Dec 3, 2019

2020 SP1 での更新項目

不具合の修正

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

Released: Oct 9, 2019

2020 での更新項目

機能

• 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

2019 Release 3 での更新項目

機能

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

Released: Oct 17, 2018

2019 での更新項目

機能

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.

Released: Apr 17, 2018

2018 Release 2 での更新項目

機能

• Support for Teradata 16 and MariaDB 10 databases - DatabaseSpy 2018r2 adds Teradata and MariaDB databases to the long list of those supported.