Step 6: Updating the migrated product connection strings

Downloading uipathctl

uipathctl is included in the as-installer.zip installation package. To download installer.zip, see Downloading the installation packages.

Generating the configuration file

To generate the cluster_config.json configuration file, take one of the following steps:

• Option A: Generate the latest cluster_config.json file:

  ./bin/uipathctl manifest get-revision | Out-File -Encoding ascii cluster_config.json

• Option B: List all the past cluster_config.json files and determine which one you want to choose:

  ./bin/uipathctl manifest list-revisions

Replacing the connection string and starting the installation

1. Provide the new connection strings for the installed products.
   • To provide the restored connection string to the Orchestrator service, add or update sql_connection_str under orchestrator in the cluster_config.json file:

     "orchestrator": {
       "sql_connection_str": "<restored orchesrator connection string>",   (added line)
       "enabled": true
     }

   • If Test Automation tables are placed inside the standalone Orchestrator database, you can also add the same connection string for Test Automation feature inside the cluster_config.json file:

     "orchestrator": {
       "testautomation": {
         "enabled": true,
         "sql_connection_str": "<restored orchestrator connection string>"
       },
       "sql_connection_str": "<restored orchestrator connection string>",   (added line)
       "enabled": true
     }

   • To provide the restored connection string to the Insights service, add or update sql_connection_str under insights in the cluster_config.json file.

     "insights": {   
        "sql_connection_str": "<restored connection string>",   (added line)
        "enabled": true }

2. Update the cluster_config.json file by running the installer.
   • To migrate Orchestrator only, run the following command:

     ./bin/uipathctl manifest apply cluster_config.json --only orchestrator --versions versions/helm-chart.json

   • To migrate Insights only, run the following command:

     ./bin/uipathctl manifest apply cluster_config.json --only insights --versions versions/helm-chart.json

3. Remap the organization IDs in the Insights tables.

   For more details, see Remapping the organization IDs.