3

I have to migrate some legacy data from stand-alone sql server database to sharepoint list.

I'm going to use programmatic approach and write a code that communicates with sharepoint list asmx web service.

Are there some "data transformation wizards" to simplify such a task or a better approach to port legacy data from sql server database to sharepoint list?

Thank you in advance!

Improve this question

1 Answer 1

Reset to default
1

I haven't seen anything to do this specifically. Writing the code for the inserts using the list web service is pretty quick and easy though. You shouldn't be looking at more than a few dozen lines of code tops.

Improve this answer
2
  • Thank you, Mike! I was advised also to put an eye on Office 2010 capabilities. It has Sharepoint export with some limitations
    – Andrew Florko
    Commented Oct 16, 2010 at 8:31
  • If you want to use MS Office, you can use Access to import data to SharePoint. If you have linked tables from SQL that may make it pretty easy. Here are some instructions. office.microsoft.com/en-us/access-help/…
    – Mike Oryszak
    Commented Oct 16, 2010 at 13:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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