Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 HOW TO SAVE IMAGE AS BINARY ON SQL SERVER

Author  Topic 

amitkumarmadhukar
Starting Member

45 Posts

Posted - 2004-06-26 : 10:08:36
HI,
I WANT TO SAVE IMAGES IN BINARY FORM ON SQL SERVER (DONT SUGGEST FILE SERVER TECHNIQUE, I ALREADY KNEW IT).

I ACTUALLY, WANT TO SAVE THE IMAGES IN BINARY FORM AND TAKE THE BACKUP OF SQL DATA AND USE ON ANOTHER MACHINE. THAT'S WHY FILE SERVER TECHNIQUE IS NOT SUPPORTED.

I WANT TO DEVELOP THIS THROUGH THE INTERFACE DESIGN IN VISULA BASIC
OVER SQL SERVER.

EX OF CODING IS VERY MUCH REQUESTED.

amit kumar madhukar

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-06-26 : 22:06:15
http://www.sqlteam.com/item.asp?ItemID=986
http://www.dotnetspider.com/Technology/KBPages/558.aspx
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-06-26 : 22:36:09
I ACTUALLY, WANT TO SAVE THE IMAGES IN BINARY FORM AND TAKE THE BACKUP OF SQL DATA AND USE ON ANOTHER MACHINE. THAT'S WHY FILE SERVER TECHNIQUE IS NOT SUPPORTED.

Yes it is. You store the files on one server with the location in the database. You enter the new location you want the files, SQL Server copies them over using ftp or robocopy and makes a new entry in the database. Do that in your Visual Basic over SQL Server design.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -