asked on
Storing Word Documents in SQL Server
I am aware that the advised method of doing this is to store the documents on the file system and use SQL for the file information. Aside from this, I'd like to store a copy of the document in SQL Server itself. I have no problem getting the files into SQL, but am not sure how to write them back out to the hard drive so that the exported file is essentially identical to the original file.
If you can gives specifics, I'd really appreciate it, thanks.
-Mari
If you can gives specifics, I'd really appreciate it, thanks.
-Mari
Microsoft SQL Server
Last Comment
Éric Moreau
You should use the image data type. There you can store .pdf, .doc, or anything like that
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Why dont you consider Sharepoint
its perfect for storing documents
but if you want to do it with sql directly
check out this post
http://social.msdn.microsoft.com/forums/en-US/vbgeneral/thread/0fb5fd05-3eb5-4568-9e2a-fd9ba5ed5a3e
it has useful links
http://www.codeproject.com/KB/database/Store_and_manipulat_BLOBs.aspx
its perfect for storing documents
but if you want to do it with sql directly
check out this post
http://social.msdn.microsoft.com/forums/en-US/vbgeneral/thread/0fb5fd05-3eb5-4568-9e2a-fd9ba5ed5a3e
it has useful links
http://www.codeproject.com/KB/database/Store_and_manipulat_BLOBs.aspx
I would use a filestream: http://www.emoreau.com/Entries/Articles/2009/09/Microsoft-SQL-Server-2008--The-FileStream-feature.aspx