How to export software image from msSQL?

How to export software image from msSQL?

Hello

There is no straightforward way of doing this so I found a workaround, but you'll need to have some programming skills for this, PHP specifically. You can create a PHP script using this code: 

<? PHP

Require ("dbLayer.php"); //connection to the database

$IMG_ID=$_GET['id']; //The image id you want to retrieve



$query=<<<SQL

SELECT data

FROM images

WHERE id=$IMG_ID

SQL;

$res=mysql_query($query);

While ($o=mysql_fetch_object ($res)) {

  //Output JPG version of the image

  Header ('content-type: image/JPEG');

  imagejpeg (imagecreatefromstring ($o->data));

  Exit ()

}

?>

Then you must create image tag, it should look like this: 

<img src="image.php? id=12345" alt=""/>
Now your picture will be displayed in the browser and you download it, just right mouse click on a picture and click save picture as.
Cheers.

How to export software image from msSQL?

Hello,

There is no "original" provider to write the image file (or read/write of files of any kind). You can read/write files from t/SQL enabling OLE Automation, or with the aid of the clr.
If you are trying to keep all the code in the stored procedure, and then OLE Automation is somehow easier.

First, you need to enable extended stored procedures (DBA you might need to do this if you do not have sufficient privileges):

> sp_configure ' show advanced options ', 1;
> Then go go sp_configure ' configuration; Ole Automation procedures ', 1;
> Then go configure;

Then, read/write only using the sp_OAMethod, and sp_OASetProperty,

As well as in the:

@ INT declare
@ imageBinary objStream "varbinary (max)
@ filePath article VARCHAR (8000) EXEC sp_OACreate ' ADODB. Stream,
@ output EXEC objStream sp_OASetProperty
@ objStream, ' type ', 1 EXEC Sp_OAMethod
@ objStream EXEC sp_OAMethod
@ objStream "open", "write ', null,
@ imageBinary EXEC sp_OAMethod
@ objStream, ' savitovili ', NULL,
@ article filePath, EXEC sp_OAMethod
@ objStream, EXEC sp_OADestroy
@" close "objStream 2

Hope it will work.
Thanking you
Franke Mary