0

I'm looking for advice on how to move an entire SQL database - with multiple linked tables into a Sharepoint site, with each table becoming its own list. I don't need them to sync, just to move all the data off the SQL database once. Is there a tool or feature that will ease this migration or will I have to do it manually?

2
  • Do you want to keep the same structure and relationships? Jul 14, 2016 at 13:38
  • Yes, I need to keep the same relationships
    – seriestoo2
    Jul 14, 2016 at 16:27

1 Answer 1

0

You can do it with couple of ways.

  1. Export the SQL table data into Excel, then import that excel file into SharePoint list.
  2. You can use 3rd party tools i.e List Bulk Import
  3. You can think about the BCS using the external list.

Your Answer

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

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