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?
Modified 6 years, 11 months ago
Viewed 104 times
Do you want to keep the same structure and relationships?– Amal HashimJul 14, 2016 at 13:38
Yes, I need to keep the same relationships– seriestoo2Jul 14, 2016 at 16:27
Add a comment |
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.