Download image datatype to Jpegs or GIF's

[mcgrathml@gmail.com]

Hi,

I want download photos (image datatype) from a SQL-2000 database
into windows based jpeg files (one for each record). Just wondering is
there any way of doing this without using TEXTCOPY?

Michael

[Erland Sommarskog]

Re: Download image datatype to Jpegs or GIF's

(mcgrathml@gmai l.com) writes:[color=blue]
> I want download photos (image datatype) from a SQL-2000 database
> into windows based jpeg files (one for each record). Just wondering is
> there any way of doing this without using TEXTCOPY?[/color]

There is no other program that comes with SQL 2000 for the task, but you
could write your own. Or search on Google to see if you can find anything.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Maury]

Re: Download image datatype to Jpegs or GIF's

mcgrathml@gmail .com ha scritto:[color=blue]
> Hi,
>
> I want download photos (image datatype) from a SQL-2000 database
> into windows based jpeg files (one for each record). Just wondering is
> there any way of doing this without using TEXTCOPY?
>
> Michael
>[/color]
You can write a simple .net program to read/write
images (as byte streams) on a BLOB field
of a SQL Server (or Access) database.

If you are interested I can post you the
(small and simple) code...

Bye
M.A.

[Madhivanan]

Re: Download image datatype to Jpegs or GIF's

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

Madhivanan

[mcgrathml@gmail.com]

Re: Download image datatype to Jpegs or GIF's


Maury,

Please email/post details of code.

Michael.





Maury wrote:
[color=blue]
> mcgrathml@gmail .com ha scritto:[color=green]
> > Hi,
> >
> > I want download photos (image datatype) from a SQL-2000 database
> > into windows based jpeg files (one for each record). Just wondering is
> > there any way of doing this without using TEXTCOPY?
> >
> > Michael
> >[/color]
> You can write a simple .net program to read/write
> images (as byte streams) on a BLOB field
> of a SQL Server (or Access) database.
>
> If you are interested I can post you the
> (small and simple) code...
>
> Bye
> M.A.[/color]