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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-07-10 : 22:19:17
|
| So far, I haven't had a need to store files in SQL server, but I've read the negative comments in this forum about how difficult or error prone it can be. I'd always considered it to be somthing I wouldn't try.There's a cover story about how easy it is (supposed) to be at asp.net PRO. I was wondering if there was anything new in the article to make storing files in SQL work well or if the article is blowing smoke?SamIf you don't have the magazine, it's available online (if you give them registration information) at [url]https://www.aspnetpro.com [/url] |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-10 : 23:42:51
|
| I think the ADO.Net providers do make it easier, even ADO made it pretty easy to do. But IMHO having to rely on ADO to do this isn't a great thing. For others it's no problem at all, and if they have no trouble with it that's fine. I would pull my hair out in short order though. Nevertheless there are other factors that warrant against doing it:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=21839And even if none of those things are issues, it is still much easier to copy files around than it is to extract them from the database. You can't use a Word doc, JPEG file, or MP3 directly from an ADO stream or as a chunk of memory, it has to be written to a file before the software can do anything useful with it. I just don't see the sense in making three left turns when one right turn gets me to the same place.I'm not saying the article is BS (I'm not reading it cause I'm not sending them my credit card just to read one article) but these are essential facts that remain no matter what the methodology is. I'm sure there are situations where this is just what some people need and it will work perfectly for them, you'll have to decide for yourself. |
 |
|
|
|
|
|
Curious