tiff & pdf file storages - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

tiff & pdf file storages

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-09 : 08:46:21

kanisious writes "TO : SQLTEAM

I am developing a document archiving system, and i am considering using sql server as the back end , my question is what field type must i use for the document, and is it feasible to use sql server as the backend when scanning around 40000 documents a week. I am considering to store the whole document in the database not the reference.

Thanks in advance
Kanisious"

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-03-09 : 08:58:38

You can use the image datatype, but I would suggest storing your documents on a share and just adding pointers to the database..