How can I export the images from my database?

Asked Dec 28 '20 at 17:10

Active Dec 29 '20 at 11:25

Viewed 296 times

I have to export images (blob) from my database (Firebird) using IBExpert, how can I do it?

edited Dec 29 '20 at 11:25

Mark Rotteveel

asked Dec 28 '20 at 17:10

Seertuuu

I'd just fire-up LinqPad and use `OleDbConnection`. – Dai Dec 28 '20 at 17:12
I have removed your off-topic request for suggestions for alternative tools. – Mark Rotteveel Dec 29 '20 at 11:30
1

I don't use IBExpert myself, but the [documentation](https://www.ibexpert.net/ibe/pmwiki.php?n=Doc.DefinitionBlob) suggests you can export through the IBExpert [Blob Viewer/Editor](https://www.ibexpert.net/ibe/pmwiki.php?n=Doc.BlobViewer-Editor) – Mark Rotteveel Dec 29 '20 at 11:31
Alternatively, you can use [ISQL's blobdump](https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/isql/firebird-isql.html#isql-command-blobdump). – Mark Rotteveel Dec 29 '20 at 11:35
IBExpert comes with IBScript engine, i don't know if it includes commands for Windows File I/O – Arioch 'The Dec 31 '20 at 17:17
Related, possibly duplicate: [Basic info on how to export BLOB as files](https://stackoverflow.com/questions/29212166/basic-info-on-how-to-export-blob-as-files) – Mark Rotteveel Jan 01 '21 at 12:18

0 Answers0