Quick User Guide

To use this tool, follow below steps.

1. Run maven install on the project, it will create binaries zip under target/assembly folder. Alternatively you can use already prepared sonar-data-migrator-binaries.zip
2. Extract zip on machine from where you have access to both sonar server DB.
3. Do sonar analysis with maven sonar:sonar command on both source and target sonar with same code.
4. Configure source and target db details in database.properties file (target DB should be mysql/postgres,oracle as target DB won't work without code change )
5. Run init.sql on target sonar db, it will create temporary tables to store migrated data details
6. Set proper java path in script.bat file (you can use script.sh for executing on Linux) .

Usage

• run the bat/sh script passing users as argument for migration of users
• run the bat/sh script passing data as first argument and project key as per "Key" value in sonar report as second argument. If key is not passed, it will work for all projects in db.

Note that script is idempotent meaning that running it multiple times doesn't create any issue as data already migrated won't migrate again. This script will migrate below things

1. Users (default sonar-users role is assigned to all migrated users)
2. Action plans associated to the project
3. All changes to issue like assignee,severity,status,action plan and resolution
4. All reviews/comments added to issue
5. All false positive data