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.
| Author |
Topic |
|
owen912
Starting Member
31 Posts |
 Posted - 2005-06-13 : 15:06:29
|
| I don’t have much experience working with the image data type or other BLOBs, and so I am not sure where to begin.I am working with some software for creating ID badges, and the vendor’s database stores photos in a table using the image data type. Now I am getting a request for exporting the captured photo to the database that manages HR functions.Doesn’t seem like it, but could it be as simple as creating an instance of a linked server and writing an update statement? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-06-13 : 15:32:27
|
| You sure this is SQL Server. Do you have the DDL of the table. When we set up our badging system, we store our pix as files on a server.Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
owen912
Starting Member
31 Posts |
Posted - 2005-06-14 : 06:45:44
|
| Yes, this is SQL Server. Storing Pix as file on a server is how I would set it up myself, but I didn't. The vendor has a utility for exporting stored images to another SQL database. Before we open up the checkbook and buy this add on utility, I want to see how much work it would be to write it myself. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-14 : 08:38:15
|
| You could use the undocumented textcopy utility. It's in the SQL Server program files directory where the SQL Server executable is stored. Run "textcopy /?" from the command line to get help on it.It's pretty easy to use, but it's not much of a user interface. You can use any programming language to extract BLOB data from SQL Server using ADO. And if you're only moving data from one server to another, DTS can handle BLOB data easily. I don't think you really need to spend money on it. |
|
|
|
|
|
|
A question regarding the export of records with th