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

I have a requirement where I need to populated a SQL Server database (tbl_Customer) with sharepoint List. I am not sure about the best approach.

approach 1: bcs to external database and scheduled content migration (if possible)

approach 2: Create store proc in the external sql database and call sharepoint web services to populate the tbl_customer table

approach 3: may a powershell script to read sharepoint list and write to sql table

Guys, I really need your judgement to I know the best approach to take. (unfortunately, they gave me 2 days to come up with the best solutions).

I would truly APPRECIATED it.

share|improve this question

1 Answer 1

up vote 0 down vote accepted

There's several ways to skin this cat, but maybe the easiest way would be to move the list from SharePoint, into your SQL table, then use BCS to consume that table so you can use it in SharePoint. Not sure on the complexity or requirements, but this would solve the issue of having the data in SQL, and making it available in SP.

otherwise, some sort of a routine (timer job, PowerShell tasked) can handle copying (duplicating) the data. Syncing at that point get's a little iffy, unless you're doing a complete overwrite each time.

HTH

share|improve this answer
    
Actually, all I am in charge of populate a sql table (for reporting purpose and BI team) with Sharepoint list data. (and what's up skining cat, that's harsh buddy, LOL). Now, what do you think about the approach. Data push from SP to SQL can be once a day. –  Rebecca Williams Nov 29 '12 at 17:12
    
what level of development experience do you have? What level of customization are you ready to implement? This could entail a PowerShell script run by Windows Tasks or a farm solution with custom code in a timer job. –  David Lozzi Nov 29 '12 at 18:08

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.