DatabaseSpy adds Binary Database Columns

2010 Release 3 adds support for binary fields and external files.
May 5, 2010
Feature Release

Altova DatabaseSpy is a multi-database query, design, and compare tool. Altova DatabaseSpy is ideal for database administrators, database developers, and other database oriented IT professionals. Altova DatabaseSpy connects to all major databases including Oracle, IBM DB2, Sybase, MySQL and more. Altova DatabaseSpy eases SQL editing and table design for a fraction of the cost of single-database solutions. Altova DatabaseSpy includes features like table browsing, data editing, SQL auto-completion, visual table design, database content comparison, and more, which all save time and ensure accuracy.

The following editions are available:

Updates in 2010 Release 3

  • Binary Database Columns and External Files
    In addition to text, numbers, or XML data, many databases contain binary fields designed to store image files or other streams of binary data. The employee database of a large enterprise, for example, is likely to contain the name, employee number, position title, and a photograph of each employee of the company. DatabaseSpy 2010 release 3 now allows users to easily process binary data in a column of a database table that is defined as a binary data type. Users may load binary data into the table from an external file, or save binary data from the database to an external file. An intuitive icon in the results table indicates columns that contain binary data. Clicking this icon opens a context menu that permits users to save existing binary data or load new data into the table. The DatabaseSpy graphical interface enables users who may not be proficient in SQL commands to conveniently manipulate binary data in a variety of databases. Datatypes supported include BLOB, raw, binary, varbinary, image, and others, depending on the database type.

For more information visit:
http://www.altova.com/Version2010Release3_Launch_050510.html

About Altova

Altova accelerates development and integration projects with software, services, and solutions that enhance productivity and maximize results. As an innovative, customer-focused company and the creator of leading software development tools - including XMLSpy, the preeminent product in its class - Altova is the choice of over 1.5 million clients worldwide and virtually every Fortune 500 company. With customers ranging from vast development teams in the world's largest organizations to progressive one-person shops, Altova's line of software applications and custom-tailored professional and educational services fulfills a broad spectrum of business needs. Altova is an active member of the World Wide Web Consortium (W3C) and is committed to delivering standards-based platform-independent development solutions that are powerful, affordable and easy-to-use. Altova was founded in 1992 and has headquarters in Beverly, Massachusetts and Vienna, Austria.

Connecting to a Microsoft Access database with DatabaseSpy.

Got a Question?

Live Chat with our Altova licensing specialists now.