Extract documents from the SharePoint farm

01 Dec

I have been asked to extract all the files from one of the SharePoint farm and put into the share drive where users can access it. I was looking around on the web and we found an article, but SQL query is incorrect in this article as Content Column is not resides in the DOCS Data-view. So, I end-up in modifying this script with creating an INNER JOIN between DOCS and DOCSTREAMS to get the binary content for the files. I have attached here is the code and screenshot of it.


Download the code here

Hope this helps.

1 Comment

Posted by on December 1, 2011 in Sharepoint


One response to “Extract documents from the SharePoint farm

  1. Adf.Ly

    April 28, 2013 at 1:47 am

    I do accept as true with all the ideas you have offered
    on your post. They are very convincing and will certainly
    work. Nonetheless, the posts are too quick for newbies.
    May you please lengthen them a little from subsequent time?
    Thank you for the post.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: