Altova DataBaseSpy Enterprise Edition 2019 Release 3

Adds conditional formatting of rows in the Results Window, plus support for Windows Server 2019.
April 03, 2019 - 8:50
New Version

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 SQL syntax for conditional formatting depends on the database type. For instance, the SELECT statement shown in this example is executed against a SQLite database.
  • Limit text search in Results Window to selection - To make working with and understanding large data sets returned by SQL queries even easier, DatabaseSpy now gives the user the option to restrict a text search to a selection of cells in the results window.
  • Support for additional database versions - DatabaseSpy and all database-enabled Altova products now support the latest version of the following databases:
    • PostgreSQL 10.
    • IBM DB2 for iSeries® 7.2, 7.3.
  • Open JDK support.
  • Support for Windows Server 2019.
Conditional formatting of rows in Results Window

Altova DataBaseSpy Enterprise Edition

Multi-database tool and SQL editor.

Got a Question?

Live Chat with our Altova licensing specialists now.