Which DatabaseSpy Edition Do I Need?

The table below shows the features included in the
Enterprise and Professional Editions of DatabaseSpy 2024.

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.

EnterpriseProfessional
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
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
PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4, 9.6, 10, 11, 12, 13, 14.1, 14.5, 15
Oracle® 9i, 10g, 11g, 12c, 18, 19
Progress OpenEdge 11.6
SQLite 3.x
Sybase® ASE 15, 16
Teradata 16