Is there any simple way to crawl all of the SharePoint 2010 site information to save it into a database?

0
votes

I'm working with Visual Studio 2010 and Sharepoint 2010. I would like to know if there's a way to have a web part that crawls all the data within a SharePoint site so I can save it into a custom db.

3
sharepoint-2010web-parts
You know it already is in a database, right? – John Saunders
Why do you need it? It IS in the database already. – Shoban
Yes well, let's say I just need a couple of info from each item, as the ID and Title let's say, to perform a couple of operations with another database of mine. The bottom line is, I do need to store some fields of certain info in a new db, despite of their existance on SharePoint's db. – Brian Roisentul
What kind of info are you needing to store elsewhere, and why? It would be easier to answer this question if we knew a little about what it is you are trying to acheive. Its strongly discouraged to mess with the sharepoint DB (manually, or through code) directly. There may be another way to acheive what you are looking to do. – Kyle Trauberman
Well, I don't want to mess with SharePoint DB, I just need to get data from all lists within a site. I does not matter why I need it. – Brian Roisentul

3 Answers

1
votes

You can certainly create a custom web part that will do this. I do not know of an out of the box web part that will work. I began writing something like this when I found SharePoint List Source and Destination. It's a CodePlex project for an SSIS SharePoint adapter. We did not need a user interface for the extract, so we used it successfully last year for transferring data between SQL Server and SharePoint.

1
votes

Sounds like all you need to do is use the API, OOB web services, or the Client OM to write some code and access the lists directly. Which approach you take depends mostly on where the code will run.

0
votes

Well I found this article - Document Library Tree View Web Part for SharePoint - it is a Web Part that shows all the info of any of the document libraries within a site. At least I know how to crawl that kind of library.