DatabaseSpy® Edition Comparison

This table shows the features included in the Enterprise and Professional Editions of DatabaseSpy® 2017. Please use this as a guide to determine which edition is most suitable for your needs.

Download a free trial of DatabaseSpy® 2017 today!

DatabaseSpy® 2017 is also available in the specially priced Altova® MissionKit® 2017. Altova MissionKit is a software development suite of industrial-strength XML, SQL, and UML tools featuring XMLSpy and other award-winning products for information architects and application developers.

.
databasespydatabasespydatabasespy   EnterpriseProfessional
  
32-bit version
64-bit version
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
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
Database Comparison and Merging  
Compare contents of tables of the same or different database types
Automatically map tables and columns with the same names
Permit manual mapping of tables and columns
Show comparison results with options to show/hide equal or different rows
Merge differences in database content directly or via change script
Compare database schemas of the same or different database types with multiple mapping options
Create merge scripts to components to update structures and components between schemas
Save database data and schema comparison settings in files for reuse
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
IBM DB2 for iSeries® v6.1, 7.1
IBM DB2® ; 8, 9, 9.5, 9.7, 10.1, 10.5
Informix® 11.7
Microsoft Access™ 2003, 2007, 2010, 2013
Microsoft® Azure SQL
Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
MySQL® 5, 5.1, 5.5, 5.6
PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
Oracle® 9i, 10g, 11g, 12c
Progress OpenEdge 11.6
SQLite 3.x
Sybase® ASE 15