Switching Insights to a different Database than the Orchestrator Database (SQL 2019)

News Knowledge Base
1

How to switch Insights to a different Database than Orchestrator Database (SQL 2019)?

Once the 2019 server is set-up, take the following steps:

  1. Disable Insights on Orchestrator (add/ remove programs)
  2. Re-enable Insights on Orchestrator but point to the existing Database
  3. Continue the Insights installation as usual.

The Insights Database will already have data in it from Orchestrator. When switching over the only data that would be affected is Robot logs and to preserve them, the steps would be:

  1. Export the current Insights Database
  2. Import it into the new server
  3. Modify the UiPath.Orchestrator.dll.config file connection string to point to the new server for the Insights connection string. (C:\Program Files (x86)\UiPath\Orchestrator\UiPath.Orchestrator.dl.config)
  4. Continue with Insights installation as usual.