ProductsNew Features IndexDatabaseSpy

Save up to 40% off the regular price of DatabaseSpy when you upgrade to the current version. Learn more . . .

Learn about all the additional capabilities you’ll get by upgrading from an older version to DatabaseSpy® 2012!

Click on the version you’re using now, then scroll up to see the major new features added in each later release. When you upgrade, you’ll gain immediate access to all this added functionality.

• DatabaseSpy® 2012 release 2 (February 23, 2012)
• DatabaseSpy® 2012 (October 19, 2011)
• DatabaseSpy® 2011 release 3 (June 8, 2011)
• DatabaseSpy® 2011 release 2 (February 16, 2011)
• DatabaseSpy® 2011 (September 8, 2010)
• DatabaseSpy® 2010 release 3 (May 5, 2010)
• DatabaseSpy® 2010 release 2 (February 16, 2010)
• DatabaseSpy® 2010 (October 28, 2009)
• DatabaseSpy® 2009 (February 3, 2009)
• DatabaseSpy® 2008 release 2 (April 29, 2008)
• DatabaseSpy® 2008 Service Pack 1 (November 6, 2007)
• DatabaseSpy® 2008 (September 12, 2007)
• DatabaseSpy® 2007 release 3 (May 30, 2007)
• DatabaseSpy® 2007 (September 19, 2006)

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

See the What’s New page for a more detailed description of the new features of DatabaseSpy® 2012 and the latest releases of Altova’s other award-winning development tools!

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)

New features DatabaseSpy 2011r3:

• Usability and UI enhancements  

DatabaseSpy® 2011 release 2 (February 16, 2011)

DatabaseSpy 2011r2 includes new advanced charting functionality:

• Advanced charting support – extends charting functionality introduced in v2011 with many new advanced chart types and features.

DatabaseSpy® 2011 (September 8, 2010)

New features in DatabaseSpy 2011 include:

• 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 5, 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)

• 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 DatatabseSpy.
• 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.

Altova DatabaseSpy Named to the 2009 SQL Server Magazine Editors' Best and Community Choice Awards "If you’re managing more than one flavor of database, you’ll want to check out this multipurpose toolset. With DatabaseSpy, database administrators can connect to not only SQL Server, but also Oracle, IBM DB2, Sybase, and MySQL."—Sheila Molnar, executive editor, SQL Server Magazine This year Altova DatabaseSpy was named to the 2009 SQL Server Magazine Editors' Best and Community Choice Awards in the “Best Database Management Product” category. Click here for the complete list.

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)

• 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 29, 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.

Redmond Roundup Champion In a comparison of database tools, Redmond Magazine selected Altova DatabaseSpy as Redmond Roundup Champion, saying DatabaseSpy is "best overall in terms of features" and "lets you do anything you may need to do with your databases." Click here for the full story.

Altova products have won many additional awards, compliments, and honors.

DatabaseSpy® 2008 Service Pack 1 (November 6, 2007)

DatabaseSpy 2008, Altova's multi-database management, query, and design tool, includes many important planned and frequently requested enhancements, all of which add up to creating a huge increase in functionality.

New features in DatabaseSpy 2008 SP1 include:

• 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.

Scroll up to see the major features added in more recent releases.

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

SQL Server Magazine Editors' Choice Awards Altova DatabaseSpy received the 2007 SQL Server Magazine Platinum Editors' Choice award in the Development Tools category. Click here for the full story.

Altova products have won many additional awards, compliments, and honors.

Scroll up to see the major features added in more recent releases.

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® 2012 – 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

Scroll up to see the major features added in more recent releases.

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.

Scroll up to see the major features added in more recent releases.

Visit the Business Managers’ Page for more information about the technological and business benefits of Altova products.