Question
How do you perform a SQL Server migration for EPM?
Answer
- Backup all DB’s This can be done through the built-in Backup tool in the EPM Server Configuration Web Console: EPM Web Console > EPM Server Configuration > Configuration > Backup Settings.
- Restore the backed-up DB files onto the new Server and configure Reporting Services on the new Server.
- Run the Revive script, please refer to solution – 000004907 - "How to restore EPM database from backup"
- Perform an uninstall of Idira EPM on the old Server
- Re-install Idira EPM on the new Server. During the re-install point the installation at the restored DB’s and input the same FQDN which was used before.
Q:
How do you perform a SQL Server migration for EPM?
A:
1) Backup all DB’s
This can be done through the built in Backup tool in the EPM Server Configuration Web Console:
EPM Web Console > EPM Server Configuration > Configuration > Backup Settings
2) Restore the backed up DB files onto the new Server and configure Reporting Services on the new Server.
3) Run the Revive script, please refer to solution – 000004907 - "How to restore EPM database from backup".
4) Perform an uninstall of Idira EPM on the old Server
5) Re-install Idira EPM on the new Server. During the re-install point the installation at the restored DB’s and input the same FQDN which was used before.