Moving a farm database to a different SQL server

To move a farm database to a different SQL server, you need to re-direct the database to the target SQL server.

  1. Create a copy of the EPM database from the source SQL server to the target SQL server.
  2. Adjust the configuration database to the target SQL server. 
    Infor.BI.Service.Console.exe ^
--job=set-configuration-database ^
--config-service-url=<configuration service host> ^
--config-service-port=8100 ^
--config-service-security-mode=None ^
--db-provider=SqlServer ^
--db-server=<new database host> ^
--db-schema-user-name=<user> ^
--db-schema-user-password=<password> ^
--db-database-name=<database name>