如何将SonarQube 6.7从MySQL迁移到Postgresql [英] How to migrate SonarQube 6.7 from MySQL to postgresql

问题描述

我们需要将SonarQube从MySQL迁移到posgresql。

We need to migrate SonarQube from MySQL to posgresql.

要实现这一点，我将从MySQL导出并导入到postgresql。我可以处理这个问题，有足够多的手册可以使用，并且我对数据库魔术还可以;）

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 ;)

但是，我的问题是：那对SonarQube有用吗一般来说？ SonarQube是否使用某些特定于数据库的魔术来消除迁移能力？

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

推荐答案

好消息：SonarQube中没有使用特定的数据库魔术。

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).

因此，如果您想从MySQL迁移到Postgresql，我强烈建议您先让SonarQube创建模式（并使用与MySQL相同的SonarQube版本）然后进行迁移，但是您可能需要为某些列（也可能是布尔类型）调整一些迁移。

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).

这篇关于如何将SonarQube 6.7从MySQL迁移到Postgresql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！