Database migration from MySQL to MSSQL for Sonarqube v6.7.7 using MYSQL Migrator tool

Ahmed, Kafeel 1 Reputation point
2020-09-29T19:52:22.193+00:00

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. please help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,561 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,881 Reputation points
    2020-09-30T02:58:57.343+00:00

    Hi @Ahmed, Kafeel ,

    --WARNING: Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path

    Please refer to this article which might help.
    For MySQL Migration tool issue, I suggest you open a thread in the MySQL forum so that people there will help you more effectively.
    In addition, you can try to use SSMA for MySQL. Please refer to this tutorial which might help.
    Best Regards,
    Amelia


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments