Online Documentation for SQL Manager for InterBase/Firebird

Setting BLOB options


BLOB and arrays options

 

In this group of options you can determine whether BLOB fields are not to be extracted, extracted as strings (should be used in case BLOB fields contain only text data), or extracted into a separate file. If the latter is selected, you also need to specify the File name (the *.blo file where the BLOB data are to be stored) and the location of the file on your local machine using the Save as... btnSaveAs button.

 

Note: Extracting BLOB fields as strings can lead to the inability to execute an SQL query because the query length is limited to 64K.

 

CheckBox Compress file

Check this option if you wish to compress the file containing BLOB data.

 

CheckBox Extract array type fields into file

Check this option if you wish fields of array type to be dumped into the file.

 

Compression

Define the desired compression level to be applied for the file: None, Fastest, Default, Best.

 

Extract Database - Setting BLOB options

 

Note: If you choose to RadioButton Extract BLOB fields into file then afterwards the result SQL file can be restored only by using the SQL Manager for InterBase/Firebird Execute Script tool.

 

Click the Next button to proceed to Selecting objects for structure extraction.