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

SonarQube Server / Community Build
1

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/sonar.properties -target /opt/sonarqube-6.7.7/conf/target.properties 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.

2

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.

3

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.