Link to home
Create AccountLog in
Avatar of Mariyam
Mariyam

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
Avatar of Epitel0920
Epitel0920

You should use the image data type. There you can store .pdf, .doc, or anything like that
ASKER CERTIFIED SOLUTION
Avatar of Amgad_Consulting_Co
Amgad_Consulting_Co
Flag of Egypt image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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