Other product variants may be available, please contact us or
request a call back
if you cannot see what you are looking for.
Product Information
DatabaseSpy 2012 R2 connects to all major databases and eases SQL editing and database structure design for a fraction of the cost of single-database solutions. DatabaseSpy provides a straightforward database connection wizard and you can even open connections to multiple databases at once. It clearly presents tables, views, stored procedures, and data in easily negotiable windows, and it also lets you directly edit database content. DatabaseSpy’s SQL Editor facilitates query writing with capabilities like code completion, syntax colouring, drag & drop editing, and more. DatabaseSpy’s powerful Database Design Editor enables graphical design and visualisation of database structures or schemas.
Altova DatabaseSpy 2012 connects to all major database types including Microsoft SQL Server 2000, 2005, 2008, IBM DB2 8, 9, IBM DB2 for iSeries v5.4, IBM DB2 for zSeries 8, 9, Oracle 9i, 10g, 11g, Sybase 12, MySQL 4, 5, PostgreSQL 8 and Microsoft Access.
New Features
New in DatabaseSpy 2012 R2
- Support for creation and editing of Oracle PL/SQL packages - work with Oracle PL/SQL packages from directly within DatabaseSpy
- Support for logical files in IBM iSeries databases - implements functionality with a wider range of IBM DB2 databases.
New in DatabaseSpy 2012
- JDBC database driver support - in addition to ODBC and ADO drivers, DatabaseSpy 2012 supports JDBC database drivers for database connections to all supported databases
- Search in project window - search functionality has been added to the Project window in DatabaseSpy 2012.
New in DatabaseSpy 2011
- Charting (Enterprise only) - Easily create charts displaying your database data. Supports a range of chart types including 2D and 3D pie, 2D and 3D bar charts, line charts, round gauge and bar gauge charts. Print charts directly or save as image files such as .png, .bmp, .gif or .jpg.
Licensing
Installed User Licence
Install and use the Altova software of any PC up to the number of licenses purchased. For example, if you purchase a 5 User Installed License, you may install and run the Software on 5 machines and all 5 users can use the software at any given point in time.
Named User Licence
Per each Named User Licence, one individual may install and use the Altova software on up to 5 computers, provided they are the sole user of the software and are not using more than one copy at any one time.
Concurrent User Licence
Install the Altova software on any number of PC's up to 10 times the number of licenses purchased, provided that only the permitted numbers of users use the software at the same time.
For example, if you purchase a 5 User Concurrent License, you may install the Software on up to 50 machines (Permitted Number of Users 5 multiplied by 10 = 50). Although the Software maybe installed on up to 50 machines, only 5 users may use the software at any given point in time.
Editions
Altova DatabaseSpy Professional
- Powerful SQL editor with refactoring support, auto completion and more
- Graphical database design to visually and edit the database schema
- Database comparison and merging enables you to compare, map and merge tables across different database systems
- Data import and export enables importing of XML and CSV formats and exporting of XML, CSV, HTML or Excel formats
- Supports a wide range of databases including SQL Server, IBM DB2, IBM DB2 for iSeries, Oracle, Sybase, MySQL, PostgreSQL and Access.
Altova DatabaseSpy Enterprise
Additionally included in the Enterprise edition:
- Charts of SQL Query Results - including 2D and 3D bar charts, 2D and 3D pie charts, round gauge charts and bar gauge charts.
Subscriptions
Purchase of the Altova Support and Maintenance Package (SMP) provides you with a range of benefits including free updates and technical support.
SMP provides:
- Free access to new releases and maintenance updates during your active subscription period (specific to the product (s) you own).
- Priority technical support via a web-based support form. Typical response times are 1-2 business days within Europe.
- Mechanism to report bugs and software faults directly to Altova.
SMP is available as either a yearly purchase, or a 2 year purchase and must be purchased at the same time, or within 30 days, of purchasing an Altova product. SMP can be renewed but must be done so before your existing subscription expires (up to 90 days in advance). It is strongly recommended that you purchase SMP with your product.