sonarqube连mysql,如何将SonarQube 6.7从MySQL迁移到Postgresql

最新推荐文章于 2024-06-21 14:48:11 发布

无敌米修

最新推荐文章于 2024-06-21 14:48:11 发布

阅读量163

点赞数

文章标签： sonarqube连mysql

本文介绍如何将SonarQube的数据从MySQL迁移到PostgreSQL。好消息是SonarQube不使用特定数据库魔法，但需要注意的是，由于某些列的类型限制，比如布尔类型，在迁移过程中可能需要手动调整。建议先用相同版本的SonarQube在PostgreSQL中创建schema，然后进行数据迁移。

摘要由CSDN通过智能技术生成

We need to migrate SonarQube from MySQL to posgresql.

To achieve this, I would export from MySQL and import to postgresql. This I can handle, there are more than enough manuals for this and also I'm OK with database magic ;)

However, my question is: would that work for SonarQube in general? Does SonarQube use some database-specific magic that would eliminate the ability to migrate?

Steffen

解决方案

Good news : there is no specific database magic used in SonarQube.

However, note that some column have different types due to limitation on some database (for instance, the boolean type).

So if you want to migrate from MySQL to Postgresql, I highly suggest to let SonarQube create the schema first (and with same version of SonarQube than the one used with MySQL) and then do the migration, but you may need to adjust some migration for some of the column (again probably for boolean type).