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?

  • Do you want to keep the same structure and relationships? – Amal Hashim Jul 14 '16 at 13:38
  • Yes, I need to keep the same relationships – seriestoo2 Jul 14 '16 at 16:27
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.
| improve this answer | |

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.