Hello fellows,
we are planning to migrate from our single node on-prem orchestrator to also an on-prem but multi node orchestrator so, any ideas about how to migrate the data between those two deployments (Assets, Queues, Processes, Orchestrator Logs, SQL server data).
i know that there is a migration tool but it only migrate data from on-prem installation to cloud or to automation suite.
aslo i know that we can recreate the assets and Queues and Packages but what about the Orchestrator Logs and SQL data how to migrate them to the new servers
Appreciate your help guys.
thanks Anil for your support, but this will expand the single node to multi node but we need to migrate to another servers i mean we need to change the SQL Server it self and the orchestrator node to another new instances
This would give you some steps and pre reqs…this can be done and then clubbed with single to multi node so that you acheive the final goal…if that helps
Cheers
To migrate UiPath Orchestrator logs and SQL data to new servers, you can follow these steps:
- Backup the SQL database:
- Connect to the SQL Server hosting the Orchestrator database.
- Open SQL Server Management Studio.
- Right-click the Orchestrator database and select
Tasks > Back Up...
. - In the
Backup
window, select the destination for the backup file and clickOK
.
- Backup the logs folder:
- On the server hosting the Orchestrator logs, navigate to the logs folder (usually located at
C:\ProgramData\UiPath\Orchestrator\Logs
). - Copy the logs folder to the destination server.
- Restore the SQL database:
- Connect to the SQL Server on the new server.
- Open SQL Server Management Studio.
- Right-click the
Databases
node and selectRestore Database...
. - In the
Restore Database
window, select theFrom device
option and click the...
button to select the backup file. - Select the
Restore
option and clickOK
.
- Restore the logs folder:
- On the new server, navigate to the logs folder (usually located at
C:\ProgramData\UiPath\Orchestrator\Logs
). - Replace the existing logs folder with the copied logs folder.
- Update the connection strings in the Orchestrator web.config file:
- Navigate to the Orchestrator installation folder (usually located at
C:\Program Files (x86)\UiPath\Orchestrator
). - Open the
web.config
file in a text editor. - Update the
connectionStrings
section to point to the new SQL Server and database.
- Restart the UiPath Orchestrator service:
- Open the Services control panel (type
services.msc
in the Start menu search). - Locate the
UiPath Orchestrator
service and restart it.