Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Please explain why sharepoint database always have to be independent ? Please let me know if its possible to save all created data in sharepoint lists on the special database which we have designed ?

I can't retrieve usefull information from sharepoint database . I think sharepoint databases with special design is not suitable for external reporting. How can I find a way which anabling me to obtain sharepoint database as well as tables that retrieve from sql database ?

share|improve this question

2 Answers 2

It is a very bad idea to interact with the SharePoint database directly, and in fact, MS will not support this. If you need to interact with the content then you need to go through the APIs, Web Services, or some other supported connector. For example, there is a connector available for SQL Server Integration Services (SSIS) that can be used to bring your content into a data warehouse or other reporting environment.

It is not possible to save SharePoint content to a "custom" database. You can expose custom databases via SharePoint, but it isn't SharePoint content.

share|improve this answer

Have a look at these related discussions:

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.