Electronic Documents storage and database in SQL server
Posted on 2013-06-03
We have a big project coming on which is about storing physical documents, papers, could be blueprints, typed documents with hand add notations, etc, in electronic format(they will be scanned) and made available trough a database and then application on top of it, web services, etc. The format will be originally in TIFF but from there we will have to come up with a more suitable format like PDF, PNG or something else. We are a Microsoft shop and we use SQL Server 2008 and 2012 and in the end the files will reside on a network location but they will be available through database tables that will point to each document. We are talking about tens of millions of documents.
The question is, actually kind of more, what would be the best way of doing this? What format to use and if the new file stream feature introduced in SQL2008 is recommendable? What are the benefits of file streaming, if any?
I thought that some of the experts may have already experience with similar situations.
Thank you in advance.