Search:
Product Details
Altova DatabaseSpy 2010 R3 boxshot.

Altova DatabaseSpy 2010 R3

Published By: 

Altova

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.

Product Variants

Altova DatabaseSpy 2010 R3, New Licence

Altova DatabaseSpy 2010 R3, SMP Renewal

Altova DatabaseSpy 2010 R3, Upgrades

New Features

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

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

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.



Vendor Showcases
Intel Logo

Embarcadero Logo

Flexera Logo

MindJet Logo

TechSmith Logo

ABBYY Logo

Becrypt Logo

Netop Logo

So Thin Logo
© 2003 - 2010 Sigma Software Distribution. Registered office: Prigg Meadow, Ashburton, Devon, TQ13 7DF, UK. Registered in England. Company no: 1671407. VAT no: GB 384904621.   Powered by Unipower