Contents
We created a new list “Projects” mapping relevant columns as per the SQL Server table and then here is my PowerShell script to import data from SQL Server to SharePoint List. write-host “Data Import Starts…” write-host “Data Import completed!”
One solution is an update/insert solution and the other is just deleting all the items in the SP list and reuploading the refreshed data from SQL. Post 1: https://powerusers.microsoft.com/t5/Building-Flows/SQL-to-Share-Point-Insert-Update/td-p/307864
Is it possible to query SharePoint content database?
As directly querying SharePoint content databases is not supported by Microsoft, and it also could cause performance issues to your SharePoint farm – Let’s not think about it further! Of course, there are 3rd party products available on the market to do this, however, PowerShell can be utilized to fulfill this requirement.
Is it easy to pull list data from SQL?
As long as it is SharePoint 2010 it is still relatively easy to pull from SQL as long as you have the list id GUID
Hello is there a relatively easy way to create a link between a Sharepoint list and a SQL Server table and i’ve read about BDC and the other one BDS or something like that, but they seemed too complex to even attempt, so getting back to SP after 5 years for a temporary project, i’m wondering if there’s now a more practical way to do this?
How to update SQL table in SharePoint list?
If you just update and add data, you can update each item according to the SQL table, compare each project number, if there is no item with same project number in the SharePoint list, create a new item, otherwise update it.
@Masoud1313 We can integrate SQL data with SharePoint. Here solution depends upon the requirement. If database is containing large amount of data in tables or any other application is connected with this database then in this case it is best to use SharePoint BCS service.