Question Locked

Saving Work documents into SQL Server

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to develop a web page in which our clients can upload word documents. We need to store it in a data base. We have more than 2000 clients. So we need to manage huge amount of data.

Is it possible to store all these data into SQL Server database?
I would b thankful to u if you can help me in this issue?

4 replies

by smithyguy

Are you wanting to store the information within the Word documents or just the entire file? Personally if I were you I would have a user upload directory stored on the file system rather than bloating your database with actual files.

by tony hopkinson

You create a table with an image column, get the file and stream it in.
Google for the code on that.

However, I'm not a big fan of putting documents into data bases.

There are three reasons to do it

Pathetically small simplification of back up (if you kept links to files, you'd have to back up the DB and the directory(s) with the files.

Distribution. If you wish to install the system in several places, again having all the 'data' in one place simplifies things.

Being able to query the document content, very problematic if using a propriety format like word, not to mention dealing with word version changes etc.

If the above aren't applicable, all you are doing is clogging your database with a mass of data it will never use, but has to manage and work around and through all the time.

This discussion is closed to new replies.