DatabaseSpy 2010 connects to all major databases, easing SQL editing and database structure design, for a fraction of the cost of single-database solutions. DatabaseSpy provides a straightforward database connection wizard and organises connections and related project files to make accessing your databases and their components effortless. 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 coloring, drag & drop editing, and more. You can easily write SQL scripts that retrieve data from multiple tables, and results can be displayed in individual, named windows for maximum clarity. DatabaseSpy’s powerful Database Design Editor enables graphical design and visualization of database structures or schemas. You can also use it to duplicate existing structures in differing database types. DatabaseSpy supports IBM DB2 (including IBM pureXML databases), Microsoft SQL Server, Microsoft Access, Oracle, MySQL, and Sybase, as well as other ADO or ODBC databases. XML support includes advanced capabilities to inspect XML data in database tables and to manage the XML Schemas used to validate that data. It exports data in five formats, including XML, XML Structure, CSV, HTML, and Excel, and it imports data from CSV files.
Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.
New Features
-
Back to top
New in DatabaseSpy 2010 R3
Insert and retrieve files from binary fields
It's now possible to load binary data into a table from a file or save binary data from the database to an external file.
New in DatabaseSpy 2010 R2
Released February 16th, the 2010 R2 release focuses on enhanced performance and numerous miscellaneous updates:
64-bit support
- Now you can use Altova DatabaseSpy natively on 64-bit systems for improved performance when working with the largest databases
Miscellaneous updates
- Supports IBM iSeries 6.1
- Option to use pure OBDC API rather than native support
New in DatabaseSpy 2010
Released at the end of October 2009, the 2010 release is a major upgrade:
Visual database schema comparison
Compare the database schema of one database with another - even across different database platforms (e.g. a SQL database and an Oracle database). Identically named components will automatically map between the two databases.
Database structure conversion
Speed up conversion of tables from one database platforms to another. Drag a table from the old server onto the new server in the design window and the SQL statements that will perform the table creation will be created automatically - even handling the different data types between database servers.
Calculate information
Select any range of cells within the results window after performing a SQL query and perform a range of calculation options, including: count, total, average, sum, min and max.
Licensing
-
Back to top
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
Subscriptions
-
Back to top
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.