Sonarqube 6.7.7 MySQL to MS -SQL Migration us MySQL Migrator tool for Linux machine

Hello Everyone,

I am upgrading SonarQube 5.6.3 to 6.7.7. Sonarqube 6.7.7 supports MySQL database but want to migrate the data from MySQL to MS SQL and will use MS - SQL . i am using MYSQL Migartor tool to migrate the data. Sonarqube is running on Linux. i have source and target both and running ./mysql-migrator -source /opt/sonarqube-6.7.7/conf/ -target /opt/sonarqube-6.7.7/conf/ command but getting below error -

WARNING: Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path: [/usr/java/packages/lib, /usr/lib64, /lib64, /lib, /usr/lib]
This driver is not configured for integrated authentication. ClientConnectionId:6cfebd6d-b412-4cbc-8937-f2ebd5869969

i copied dll files on to linux box at /usr/java/packages/lib, /usr/lib64, /lib64, /lib, /usr/lib] but no luck and set integrated security =true for target but no luck.

Hi @kafeel, welcome to the SonarSource Community!

I don’t think you’re going to see success trying to load a .dll file from a process running on a linux box.

A quick google search yielded what might be some fruitful hints for you.

Thanks for the prompt response Jeff. could you please suggest me any another tool apart from SSMA and MYSQL Migrator for MYSQL to MS SQL migration for our SonarQube.