ProductsDatabaseSpyEdition Comparison

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

Download a free trial of DatabaseSpy® 2012 today!

DatabaseSpy® 2012 is also available in the specially priced Altova® MissionKit® 2012. Get up to 8 software tools for the price of 2 with the Altova® MissionKit® 2012! The MissionKit is an integrated suite of XML, database, and UML tools designed to meet the needs of software architects and XML developers.

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
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
Microsoft® SQL Server® 2000, 2005, 2008
IBM DB2® 8, 9
IBM DB2 for iSeries® v5.4, 6.1
Oracle® 9i, 10g, 11g
Sybase® 12
MySQL® 4, 5
PostgreSQL 8
Microsoft Access™ 2003, 2007