What way would be the best to move BI Center to other SQL server in SharePoint 2013? Thanks,
To move the BI Center Site collection,
- Make Sure All services Application are created and associated to the web application which you want to move the BI Site
- Now backup the Content DB of the BI Site collection.
- Restore into the Production SQL Server.
- Mount the DB to desired web Application.