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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-17 : 13:32:29
|
| Shawn Rusin writes "I need to setup a database able to store files like,DWG, PDF, DOC, XLS and so on.One, can SQL do this?Two, where can I go for information on how to build a database that can do this. Does SQL Books on line cover this if so where do I start my search. Is there a good book out there that will help me?I have been using SQL for 5 years but it has always been for accounting data and access control data never file's.(Goal)I'm building a web site using Macromedia Flash MX and I want to access files that are stored in SQL server 2000. My O/S is Server 2000 pro. Please help me and thank you for your time,Shawn RusinWEB Design/ Data Admin" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-17 : 13:35:54
|
| The best advice we can give you is: DON'T do it this way.If the files are already in SQL Server, and if you can, try try try to ouput them into individual files on the hard drive. Why? You'll save disk space and you'll be able to manipulate them better. Store a link in SQL Server to the file location, but don't put the file contents in the table.This is especially true in web-based apps like yours; SQL Server only adds extra layers of processing to the mix without any real advantage. You have to jump through hoops getting the content out instead of just a simple link. This is hard enough to do in HTML and ASP, it's probably worse in the case of Flash. And ultimately, the only way this works is to extract the contents TO A FILE ON THE WEB SERVER anyway, so why not just store it like that in the first place?Take a look at the SQL Team FAQ if you have more questions about this, there's something in there. |
 |
|
|
|
|
|
|
|
File database in SQL