0

I am trying to query sharepoint lists data with sql server,for performance reasons. Is there any tool to help me do this? I heard about spud and SPViews but i am searching for something open source or maybe a work around.

Improve this question
6
  • 1
    Querying SharePoint databases directly is not supported. Can you expand on what you are attempting to accomplish? All queries need to leverage a supported SharePoint API. Commented Apr 16, 2021 at 16:23
  • the API is very low to get large chunks of data that is why i want to customize how i get list data Commented Apr 16, 2021 at 16:28
  • Use CSOM which will only grab a minimal set of data plus the data you select. Querying databases directly is not supported. Commented Apr 16, 2021 at 16:29
  • i will try that but there is some tools like SPViews or axioworks (axioworks.com/sqlist) that do the job Commented Apr 16, 2021 at 16:33
  • 1
    Any tool that access the database directly is performing an unsupported operation. Use at your own risk. SPViews, if you add the view to the database, will likely result in a database that cannot be updated by patches or version to version upgrades. Commented Apr 16, 2021 at 16:58

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.