DatabaseSpy adds Binary Database Columns

Released: May 5, 2010

Updates in this release

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