0

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.

0

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

  • 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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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