The table below shows the features included in the
Enterprise and Professional Editions of DatabaseSpy 2025.
DatabaseSpy is also available in the Altova MissionKit, a software development suite of industrial-strength XML, SQL, and UML tools featuring XMLSpy and other award-winning products - all at a special discounted price.
Enterprise | Professional | |||
---|---|---|---|---|
![]() | ![]() | 32-bit version | ![]() | ![]() |
![]() | ![]() | 64-bit version | ![]() | ![]() |
![]() | ![]() | AI Assistant | ![]() | ![]() |
![]() | ![]() | AI-powered extensions | ![]() | ![]() |
SQL Editor | ||||
![]() | ![]() | Generate a variety SQL statements in the Online Browser based on existing tables and columns, including SELECT, CREATE, INSERT, DROP, and more | ![]() | ![]() |
![]() | ![]() | Generate complete DDL scripts for a database schema | ![]() | ![]() |
![]() | ![]() | Open and save SQL statements in files for reuse | ![]() | ![]() |
![]() | ![]() | Color-coded auto-formatting with collapsible regions and named result windows | ![]() | ![]() |
![]() | ![]() | Customized appearance of SQL code for each supported database | ![]() | ![]() |
![]() | ![]() | Refactoring menu to add or remove semicolons and quotation marks, or automatically remove comments from SQL statements | ![]() | ![]() |
![]() | ![]() | Dynamic autocompletion window for SQL editing with options to display and insert names of tables, views, columns, functions, datatypes, procedures, and keywords | ![]() | ![]() |
![]() | Support for SQL queries that contain parameters (SQL Templates) | ![]() | ||
![]() | ![]() | Edit views and stored procedures | ![]() | ![]() |
![]() | ![]() | Display query results in multiple named or stacked results tables | ![]() | ![]() |
Charts of SQL Query Results | ||||
![]() | Line charts | ![]() | ||
![]() | 2D and 3D bar charts | ![]() | ||
![]() | Stacked bar charts | ![]() | ||
![]() | 2D and 3D pie charts | ![]() | ||
![]() | Area charts | ![]() | ||
![]() | Stacked area charts | ![]() | ||
![]() | Round gauge charts | ![]() | ||
![]() | Bar gauge charts | ![]() | ||
![]() | Candlestick charts | ![]() | ||
![]() | Chart overlays | ![]() | ||
![]() | Chart background images and color gradients | ![]() | ||
![]() | Customize chart titles, axis ranges, colors, fonts, and sizes | ![]() | ||
![]() | Save charts as .png, .bmp, .gif, and .jpg image files | ![]() | ||
Graphical Database Design | ||||
![]() | ![]() | Display tables and relationships in graphical view | ![]() | ![]() |
![]() | ![]() | Add or modify database tables | ![]() | ![]() |
![]() | ![]() | Add or modify columns with datatypes, lengths, nullable characteristics | ![]() | ![]() |
![]() | ![]() | Add or modify indexes, keys, and check constraints | ![]() | ![]() |
![]() | ![]() | Build database change script to execute immediately, send SQL editor, or save in a file | ![]() | ![]() |
![]() | ![]() | Save graphical database diagrams as .png or .emf image files | ![]() | ![]() |
Data Import and Export | ||||
![]() | ![]() | Import data from XML or CSV formats | ![]() | ![]() |
![]() | ![]() | Import data directly or generate a SQL import script | ![]() | ![]() |
![]() | ![]() | Export data in XML, CSV, HTML, or Excel formats | ![]() | ![]() |
Supported Databases | ||||
![]() | ![]() | Firebird 2.5, 3, 4 | ![]() | ![]() |
![]() | ![]() | IBM DB2 for iSeries® v6.1, 7.1, 7.2, 7.3, 7.4 | ![]() | ![]() |
![]() | ![]() | IBM DB2® ; 8, 9, 9.5, 9.7, 10.1, 10.5, 11.5, 11.5.7 | ![]() | ![]() |
![]() | ![]() | Informix® 11.7, 12.10, 14.10 | ![]() | ![]() |
![]() | ![]() | MariaDB 10, 10.3, 10.4, 10.5, 10.6.5, 10.9.2, 10.11, 11.2, 11.4 | ![]() | ![]() |
![]() | ![]() | Microsoft Access™ 2003, 2007, 2010, 2013, 2019 | ![]() | ![]() |
![]() | ![]() | Microsoft® Azure SQL | ![]() | ![]() |
![]() | ![]() | Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016, 2017, 2019, 2022 | ![]() | ![]() |
![]() | ![]() | MySQL® 5, 5.1, 5.5, 5.6, 5.7, 8, 8.0.25, 8.0.28, 8.2, 8.3, 8.4 | ![]() | ![]() |
![]() | ![]() | PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4, 9.6, 10, 11, 12, 13, 14.1, 14.5, 15,16 | ![]() | ![]() |
![]() | ![]() | Oracle® 9i, 10g, 11g, 12c, 18, 19 | ![]() | ![]() |
![]() | ![]() | Progress OpenEdge 11.6 | ![]() | ![]() |
![]() | ![]() | SQLite 3.x | ![]() | ![]() |
![]() | ![]() | Sybase® ASE 15, 16 | ![]() | ![]() |
![]() | ![]() | Teradata 16 | ![]() | ![]() |