Huisman Equipment had a product portfolio, which due to it’s success has grown very large and caused performance issues. These performance issues were mainly caused by web parts that were retrieving data recursively. As a solution, a hybrid plan was written. With the hybrid solution, all collaboration data will be stored in SharePoint and all recursive data will be migrated to SQL Server.
During this project, I was responsible for:
- writing the hybrid solution plan
- developing PowerShell migration script (SharePoint data to SQL)
- developing recursive reports on SQL data
- developing Excel-like input forms for the SQL data (jQuery and Handsontable)
Huisman Equipment had a product portfolio, which due to it’s success has grown very large and caused performance issues. These performance issues were mainly caused by web parts that were retrieving data recursively. As a solution, a hybrid plan was written. With the hybrid solution, all collaboration data will be stored in SharePoint and all recursive data will be migrated to SQL Server.
During this project, I was responsible for:
- writing the hybrid solution plan
- developing PowerShell migration script (SharePoint data to SQL)
- developing recursive reports on SQL data
- developing Excel-like input forms for the SQL data (jQuery and Handsontable)