I must do Data Warehouse from my lists in Sharepoint.
I need to connect to the Sharepoint and get all elements from the list and Show them in MS SQL Serwer 2008 R2. I need to show them in another server not in this which is located Sharepoint. I must done connection across them.
I see that all content are in database called WSS_Content.
Please tell me how to list all data from another server in another server in which aren't Sharepoint instaled.