Leapwork Platform to Enterprise Migration

Introduction

Leapwork offers users three different types of licenses i.e. Trial, Platform & Enterprise. In this article, we will learn how to smoothly migrate using the Leapwork automation tool from a Platform Version to Enterprise Version.

Prerequisites

1. Upgrade the .NET Framework to the VERSION 4.8 (versions prior to 2025.2), VERSION 6 (versions from 2025.2 onward), VERSION 8 (versions from 2025.3.0).

2. To download the Leapwork software, visit https://portal.leapwork.com

3. To download the Migration Tool, Click here.

4. Make sure the MSSQL Server and SSMS are installed with the required access.

There can be two scenarios one can face while migrating to an Enterprise version of Leapwork:

• Scenario 1: Migrating to the same Leapwork version for Enterprise. E.g. (Leapwork 2022.2.700 Platform to Leapwork Enterprise Version 2022.2.700)

• Scenario 2: Migrating to an upgraded version for Enterprise. E.g.: (Leapwork 2022.2.539 to Leapwork 2022.2.700)

In Scenario 1, there is no need to upgrade the platform version, and we can directly jump to “Step 1 - Backup Process”.

In Scenario 2, Upgrade the Leapwork version to the version on which we are migrating to the enterprise. (Recommended to follow a backup process before upgrading), after the upgrade please follow the process from "Step 1- Backup Process".

Step 1 - Backup Process

To prevent data loss and prepare for any unforeseen problems during the migration, we strongly encourage you to perform a backup of Leapwork before starting the migration process.

Recommended Steps

1. Export all the flows and save them.

2. Stop Leapwork Controller service and take a backup of C:\Program Files\Leapwork\Assets folder, which has SQLite database files. Refer to this article for backup best practices. Click here.

3. Save the encryption key for the database, including the admin password.

Step 2 - Uninstall the Previous Version

Uninstall the Platform version of Leapwork from the machine.

1. To uninstall the Platform version, Go to Control Panel – Program & Features.

2. Select Leapwork and uninstall it.

3. Remove the folder C:\Program Files\Leapwork

**_Note - Ensure you have taken a backup of the Assets before deleting this folder._*

4. Remove the Leapwork folder from the registry editor.

Path - Computer\HEY_LOCAL_MACHINE\SOFTWARE\Leapwork

Step 3 - MSSQL Server Database user permissions

1. Open SSMS connect to SQL Server

2. Go to security - login - username, right-click and go to the properties.

3. Check Server Roles, the user must have dbcreator and public roles selected.

4. In User Mapping, the user should have a public role map with the master, asset & report database.

Step 4 - Install the Enterprise Version

1. Follow the steps from the reference article - Click here.

2. Open Leapwork studio and try to make any flow, save, modify & delete just to confirm you have all the necessary permissions over the database created in the enterprise installation.

Step 5 - Migration

By default, in the Migration Tool, the configuration tab will not be enabled. To enable follow the steps in the reference article - Click Here.

1. Open the Migration Tool.

• Encryption Key – Encryption key of platform version database
  • Username – MSSQL username
  • Password – MSSQL password
  • Server Address – Hostname or IP of the machine on which MSSQL is hosted/installed.
  • Initial Catalog – Leave it to default “master”.
  • Integrated Security – Leave it to default SSPI.
  • Connection Type– Choose “Trusted Connection” if using windows authentication for MSSQL, else choose “Standard Security” if you use SQL User authentication.
  • Asset database name – Choose the database one you have created for Asset during enterprise installation.
  • Report database name - Choose the database one you have created for Report during enterprise installation.
  • Database– Select MSSQL.

2. Click TestConnection.

3. Click Save.

Note: If you are using windows authentication for MSSQL, before performing migration go to services. Right on the LEAPWORK_CONTROLLER service, and go to properties, and go to Log On Tab. Put the credential used to log on into the MSSQL Server.

4. Click OK and restart the service.

5. In Migration Tool, STOP the controller service on the Migration tab.

6. Explore the “Assets” folder from the backup, select all the SQLite DB as shown in the above image.

7. Click on Migrate, a popup will appear for the encryption key. Enter the encryption key for the SQLite database saved in the backup process.

8. Wait for the Migration to finish.

9. Click Configuration and start the controller service.

10. Launch Leapwork.

11. Click on the hyperlink and generate the license key for the enterprise version, Enter the license key and you are ready to use the enterprise version.

For any clarification, contact our Priority Support.