Sharepoint 2010 Foundation - Automating List export into SQL 2008 Database

allenkent
allenkent used Ask the Experts™
on
I have a Sharepoint list (Calendar) and I want to get data into a different SQL Server Table every 5 minutes (live Linked Server would be awesome but in my dreams i think). I can build SQL job that runs every 5 minutes but I just cannot seem to grab the data. Options would be great.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
Just and idea, but would take some work. You can use Powershell to extract data from either source and write to the other.

Good luck...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial