Online Documentation for Data Comparer for SQL Server

Viewing BLOB data

Data Comparer for SQL Server provides a BLOB viewer for browsing the content of BLOB (Binary Large Object) fields being compared.

The tool can be invoked from the data grid at Step 3 by clicking the ellipsis button next to a record of the BLOB field. Use the combo-box control in the upper area of the viewer to specify the field for viewing.

Please note that BLOB Viewer is only available if the Compare BLOB values option has been checked at Step 2 of the wizard.

When working with the BLOB viewer, you can use the drop-down list in the top left corner of the window for quick navigation.

The drop-down list allows you to switch the source/target fields easily.

Switch between the BLOB viewer tabs to explore the field content.

The Hexadecimal tab allows you to view the BLOB data as hexadecimal dump.

The Text tab allows you to view the BLOB data as plain text.

Specify text encoding in the Encoding drop-down list.

The Rich Text tab allows you to view the BLOB data in Rich Text format (RTF).

The Image tab allows you to view the BLOB data as an image.

The HTML tab allows you to view the BLOB data as HTML (Hyper-Text Markup Language format) - in the way this data would be displayed by your Internet browser.

The Multimedia tab allows you to view the BLOB data as a multimedia (audio/video) file.

Use the Play , Pause , Stop buttons to navigate within the multimedia content.

Having finished browsing the BLOB data, you can close the editor and continue browsing data comparison results in the grid.