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?
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.