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 |
|
brodier
Starting Member
3 Posts |
 Posted - 2007-05-13 : 21:26:02
|
| I have an SQL 2000 database which has 30,000+ small images stored as blob files. I would like to create an export function (to run daily), so that i can save these blob images on a local drive. Is this possible? and if so could you please point me in the right direction.Cheers,Brodie |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-13 : 22:23:46
|
| Why store them in db then? |
 |
|
|
brodier
Starting Member
3 Posts |
Posted - 2007-05-13 : 22:32:29
|
| it wasn't my choice, it is a commercial application (student database application) which stores them as blobs in the database. |
|
|
|
jfilan
Starting Member
1 Post |
Posted - 2007-05-24 : 13:56:19
|
| brodier,did you find a solution yet?josh |
|
|
|
brodier
Starting Member
3 Posts |
Posted - 2007-05-24 : 20:24:14
|
| unfortunately not :( |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-24 : 20:36:37
|
| You can't use SQL Server to import/export the blobs to/from the database. You must use a front-end application to do this. You should post your question in a forum that specifically deals with the programming language that you are using. For .NET applications, I recommend www.asp.netTara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Export BLOB - SQL 2000