Forum Discussion
Doug Allen
Mar 09, 2018Iron Contributor
Move SharePoint 2013 PowerPivot to new SQL Server
I can't find clear documentation on this so looking for any clarification or confirmation. Have SharePoint 2013 on prem using PowerPivot and wants to move the instance to another SQL server.
M...
SteveKnutson
Feb 14, 2019MVP
I think you are on the right track with the migration method. I recommend using a SQL Alias, so that in the future you only need to update the Alias if you change SQL Servers again.
The PowerPivot data sources only need to be changed if you are changing the data source location.
This article relates to upgrading between SharePoint versions but has some points that may be useful