New in DatabaseSpy 2018

Version 2018 of Altova DatabaseSpy became available on October 3, 2017. Learn about all the new features below and update to the latest version.
DatabaseSpy® 2018 (October 3, 2017)
Enterprise
Professional
DatabaseSpy® 2018 (October 3, 2017)
Support for SQL templates
Support for foreign key enforcement in SQLite
Support for Sybase 16, PostgreSQL 9.6, MySQL 5.7

Support for SQL Templates

DatabaseSpy 2018 includes support for SQL queries that contain parameters, also known as SQL Templates. Parameters can make a query much more flexible, for instance allowing users to easily test complex join statements with multiple values.
The DatabaseSpy 2018 SQL Editor and result windows at the top left below show a query to report all orders of a specific product by a specific customer.
This query could be much more flexible by replacing the product name ‘sprockets’ and the customer number 525 with parameters, as shown in the second query window above where the parameters :pname and :custnum are substituted for the product and customer.
Support for SQL templates in DatabaseSpy
When the query with parameters is run directly using the Execute button at the top left of the SQL Editor window, DatabaseSpy 2018 opens a dialog allowing the user to enter values for execution, and the result shown at the lower right is generated.
SQL Templates for DatabaseSpy 2018 can be saved in a special projects folder and executed dynamically. The example of direct execution shown above is fine if the user already knows the desired parameter values. Often, however, a user needs to create queries that generate test results to explore unfamiliar data. After a test query is executed, the user can select values from the result table and supply them as parameters to a SQL template stored in the project templates folder.
A new SQL Editor window opens with an automatically-generated query based on the template with selected values assigned to the parameters, the generated query is executed, and the result table is shown.
DatabaseSpy 2018 is a powerful tool for prototyping queries with parameters that are often required in other projects such as database mappings in MapForce or database data sources in MobileTogether.
Supplying parameter values from a result table in DatabaseSpy

Support for Foreign Key Enforcement in SQLite

Users can now optionally enable or disable foreign key enforcement in SQLite to enable cross-table checks when working with data. For example, when foreign keys are enabled, it is not possible to delete a record from a table if it has dependencies in another table.
The choice to enable or disable foreign keys is selected on the connection dialog as seen at right:
Supplying parameter values from a result table in DatabaseSpy

Support for Sybase 16, PostgreSQL 9.6, MySQL 5.7

DatabaseSpy 2018 now adds support for Sybase 16, PostgreSQL 9.6, AND MySQL 5.7, in addition to previously-supported versions of these databases.
Update
Existing customers may update to the latest version here
Download
Download a fully functional, free 30 day trial of any Altova product now!
New in MobileTogether
Support for Push Notifications and other new features for cross-platform mobile app development in MobileTogether 4.0

New Features in Previous Versions

Learn about all the additional capabilities you’ll get by upgrading from an older version to DatabaseSpy 2018.
DatabaseSpy® 2017 Release 3 (April 4, 2017)
Enterprise
Professional
DatabaseSpy® 2017 Release 3 (April 4, 2017)
New command to generate complete DDL scripts for a database schema
New Find bar
Numerous new features for charting SQL query results
Windows Server 2016 Support
DatabaseSpy® 2017 (October 4, 2016)
Enterprise
Professional
DatabaseSpy® 2017 (October 4, 2016)
Enhanced database support – support for ADO.NET database drivers, native support for PostgreSQL, support for Progress OpenEdge, support for SQL Server 2016
DatabaseSpy® 2016 Release 2 (February 16, 2016)
Enterprise
Professional
DatabaseSpy® 2016 Release 2 (February 16, 2016)
Support for asynchronous execution of user SQL statements including simultaneous execution of multiple statements in separate windows
DatabaseSpy® 2016 (September 30, 2015)
Enterprise
Professional
DatabaseSpy® 2016 (September 30, 2015)
Support for Firebird databases
Support for numerous databases updated to include newest versions: IBM DB2 10.5, SQL Server 2014, PostgreSQL 9.4, MySQL 5.6, and Oracle 12C
Windows 10 support
DatabaseSpy® 2015 release 4 (June 10, 2015)
Enterprise
Professional
DatabaseSpy® 2015 release 4 (June 10, 2015)
Support for SQLite 3.x databases
DatabaseSpy® 2014 (October 29, 2013)
Enterprise
Professional
DatabaseSpy® 2014 (October 29, 2013)
Support for new databases and database versions: Informix 11.70, PostgreSQL versions 9.0.10/9.1.6/9.2.1, MySQL 5.5.28, IBM DB2 versions 9.5/9.7/10.1, SQL Server 2012, Sybase ASE (Adaptive Server Enterprise) 15/15.7, and Access 2010/2013
DatabaseSpy® 2012 Release 2 (February 23, 2012)
Enterprise
Professional
DatabaseSpy® 2012 Release 2 (February 23, 2012)
Support for creation and editing of Oracle PL/SQL packages – PL/SQL packages are a core Oracle feature and can be found in existing databases when connecting with DatabaseSpy
Support for logical files in IBM iSeries databases – Implements functionality with a wider range of IBM DB2 databases
DatabaseSpy® 2012 (October 19, 2011)
Enterprise
Professional
DatabaseSpy® 2012 (October 19, 2011)
JDBC database driver support – Improves database connectivity for many users
Search in Project Window – Helps users manage organization of large DatabaseSpy projects
DatabaseSpy® 2011 Release 3 (June 8, 2011)
Enterprise
Professional
DatabaseSpy® 2011 Release 3 (June 8, 2011)
Usability and UI enhancements
DatabaseSpy® 2011 Release 2 (February 16, 2011)
Enterprise
Professional
DatabaseSpy® 2011 Release 2 (February 16, 2011)
Advanced charting support – extends charting functionality introduced in v2011 with many new advanced chart types and features.
DatabaseSpy® 2011 (September 8, 2010)
Enterprise
Professional
DatabaseSpy® 2011 (September 8, 2010)
Charting support – create line charts, bar charts, pie charts and gauge charts in a variety of styles on the fly from query results.
Multiple Editions – DatabaseSpy now available in Enterprise and Professional Editions.
DatabaseSpy® 2010 Release 3 (May 10, 2010)
Enterprise
Professional
DatabaseSpy® 2010 Release 3 (May 10, 2010)
Support for binary database columns and external files – insert and retrieve external files from database binary fields
DatabaseSpy® 2010 Release 2 (February 16, 2010)
Enterprise
Professional
DatabaseSpy® 2010 Release 2 (February 16, 2010)
64-bit version – DatabaseSpy is now available in a 64-bit version to run on Windows Vista 64-bit and Windows 7 64-bit systems.
Support for IBM iSeries 6.1 – support for IBM’s new iSeries version 6.1 adds to the long list of popular databases supported by DatabaseSpy.
Option to use pure ODBC API instead of native support – available for users who want to access a database via the pure ODBC API instead of Altova’s native support.
DatabaseSpy® 2010 (October 28, 2009)
Enterprise
Professional
DatabaseSpy® 2010 (October 28, 2009)
Comparison and merging of database schemas
Conversion of database structures between different database types
Calculation and display of additional information for selected results
Result grid printing
Compatibility with Windows 7
DatabaseSpy® 2009 (February 3, 2009)
Enterprise
Professional
DatabaseSpy® 2009 (February 3, 2009)
Database content comparison and merging
Native support for additional databases – SQL Server 2008, Oracle 11g, PostgreSQL 8
Support for XML fields in SQL Server
Asynchronous Query Execution
DatabaseSpy® 2008 Release 2 (April 28, 2008)
Enterprise
Professional
DatabaseSpy® 2008 Release 2 (April 28, 2008)
SQL Refactoring Menu – lets you reformat existing SQL statements and scripts to facilitate moving scripts between SQL dialects, for instance.
SQL Formatting Dialog – lets you define personal preferences for formatting new SQL statements as they are entered.
Graphical Design Editor Enhancements. – new operations to create keys, indexes, and constraints, making it easier to define table relationships in the design view.
More User-Selectable Options – gives users more extensive control over SQL auto-completion.
DatabaseSpy® 2008 Service Pack 1 (November 6, 2007)
Enterprise
Professional
DatabaseSpy® 2008 Service Pack 1 (November 6, 2007)
Expanded support for IBM DB2 – allows users to connect to IBM DB2 databases running on System i (formerly iSeries) and System z platforms.
German language version – allows German-speaking users to access all menus, dialog boxes, messages, and Help system in the German language.
DatabaseSpy® 2008 (September 12, 2007)
Enterprise
Professional
DatabaseSpy® 2008 (September 12, 2007)
Creating and editing database views – allows users to create virtual tables from the result sets of database queries, thus organizing data in a convenient and customized manner.
Support for Stored Procedures – allows users to examine, create, edit, and execute stored procedures in the SQL Editor.
Database content editing – enables users to retrieve and edit the content of existing database tables, add new rows to insert data, or delete entire rows in all supported databases.
New Data Inspector window – allows users to preview large XML and text fields in databases.
Enhanced SQL auto-completion capability – provides customizable, context-sensitive entry-helpers for auto-completion of SQL statements.
Editing indexes and constraints in the Design Editor
DatabaseSpy® 2007 Release 3 (May 30, 2007)
Enterprise
Professional
DatabaseSpy® 2007 Release 3 (May 30, 2007)
Enhanced views of tables containing XML data in the Online Browser – columns that contain XML data are identified in the database tree, and the online browser indicates any XML Schemas used to validate them.
Design editor XML enhancements – new columns containing XML data can now be added to database tables via the DatabaseSpy design editor (exclusively for IBM DB2 9 in this release).
View of registered XML Schemas in the Online Browser tree view – XML Schemas registered in XML-enabled databases are now displayed in hierarchical form (only for IBM DB2 9 in this release).
Option to send XML Schemas for view in XMLSpy® 2013 – use the Online Browser right-click context menu to send any XML Schema to XMLSpy, where it is opened in Schema View for intuitive graphical display and editing.
Management of XML Schemas registered in the database – add or drop XML Schemas from the database., or decompose an XML Schema for applications that require shredding – or decomposing – XML data into multiple columns in database tables (exclusively for IBM DB2 9 in this release).
Customization of SQL autocompletion suggestions – lets users modify the auto-completion suggestion menu to create a customized list, keeping auto-completion pop-up lists to a manageable size while offering only the suggestions individual users prefer.
Quick access to User-defined tools
DatabaseSpy® 2007 (September 19, 2006)
Enterprise
Professional
DatabaseSpy® 2007 (September 19, 2006)
Connectivity to all major databases – supports Microsoft SQL Server 2000 and 2005, Microsoft Access 2003, Oracle 9i and 10g, IBM DB2 8.x and 9, MySQL 4.x and 5.x, and Sybase 11. In fact, DatabaseSpy is designed to work with any ADO or OBDC database.
Quick connect wizard – simplifies the steps required to connect to a database.
Database project manager – a toolbox for collecting database connections along with your favorite tables, views, SQL statements, and visual database design files.
Online database browser – lets you effortlessly explore database structure or examine database content.
SQL editor – with specially designed, easy to use features to help you quickly and efficiently develop, test, and reuse SQL queries in all major relational databases.
Visual database design editor – lets you view and edit the structures of all your databases through one graphical user interface.
Multiple export formats – export data from your database in a variety of formats to suit many purposes. You can export data as XML or XML Structure, CSV, HTML, or Excel files.
And much more – a rich graphical interface to perform all major application operations visually, including icons to identify database components, convenient toolbars, color-coded text, drag and drop SQL editing, collapsible panels and helper windows, right-click context menus, tabbed results windows, graphical table displays, and a host of other visual properties.
Update
Existing customers may update to the latest version here
Download
Download a fully functional, free 30 day trial of any Altova product now!