I have a sql server 2005 table that stores a list of small pdf articles, there are over 1900 of them, I have a Title, Author and Location field which stores a link to the file, I can search for a keyword in the Title and Author field but want to be able to search the content of the pdf itself. Can I bulk insert the pdfs into the database and make that field searchable, or would that be too slow?

I have a sql server 2005 table that stores a list of small pdf articles, there are over 1900 of them, I have a Title, Author and Location field which stores a link to the file, I can search for a keyword in the Title and Author field but want to be able to search the content of the pdf itself. Can I bulk insert the pdfs into the database and make that field searchable, or would that be too slow?

Thanks for any suggestions you may have.

You will have to actually open the pdf and read it. If you insert it into the database you would have a byte array and the contents would look something like

0x255044462D312E340D0A25........

That obviously might be searchable but highly unlikely to return the desired results. The other option would be to open each file one at a time and scan them for the text you are looking for. I think I would look to CLR for something like this as just using sql is really not the right tool for the task at hand.

I have a sql server 2005 table that stores a list of small created pdfarticles, there are over 1900 of them, I have a Title, Author and Location field which stores a link to the file, I can search for a keyword in the Title and Author field but want to be able to search the content of the pdfitself. Can I bulk insert the pdfs into the database and make that field searchable, or would that be too slow?

Thanks for any suggestions you may have.

Check whether following three links can offer some useful information.