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
You can do it with couple of ways.
- Export the SQL table data into Excel, then import that excel file into SharePoint list.
- You can use 3rd party tools i.e List Bulk Import
- You can think about the BCS using the external list.
answered Jul 14 '16 at 15:07
