Migrating Sisense System Configurations

To migrate your Sisense Web Application configuration, you must copy several directories from the current environment and migrate them to the new environment.

In addition, your Sisense application database has an identifier associated with it when you install Sisense. This identifier must be deleted when migrating Sisense as each database should have its own unique identifier. A new identifier will be generated in the environment the next time Sisense is opened. You can access the database through RoboMongo and remove the identifier as described below.

To migrate the Sisense Web Application:

  1. Back up the old environment, open your machine’s Control Panel, and go to System and Security > Administrative Tools > Services, and stop the SisenseRepository service (this will make the website inaccessible).
  2. Create a copy of the entire Repository directory located at:
    %ProgramData%\Sisense\PrismWeb\Repository
  3. Replace the existing Repository directory in the new environment with the one you backed up.
  4. Create a copy of the entire Discovery directory located at:
    %ProgramData%\Sisense\Infra
  5. Replace the existing Discovery directory in the new environment with the one you backed up.
  6. In Windows Services, start the SisenseRepository service and Sisense.Discovery service.
  7. Open Robomongo and connect to your application database with a WriteUser. For more information, see Accessing the Application Database.
  8. Under PrismWebDB, go to the servers collection and edit the file with address LocalHost.
  9. Verify that the value of "identity" is the same for each application database in your configuration. It should be the same as the value in %programdata%\Sisense\PrismServer\ServerIdentity.xml. If the values are different, update the value in the database to match the value in the ServerIdentity.xml file.
  10. Open Windows Services and restart the following services:
    • Sisense.Configuration
    • Sisense.Galaxy
    • Sisense.Gateway
    • Sisense.Identity
    • Sisense.Plugins
    • Sisense.ECMServer
    • Sisense.ECMLogs
    • Sisense.Jobs
    • Sisense.StorageManager
  11. Open the IIS Manager and restart the website SisenseWeb.