{"id":2045,"date":"2019-04-27T14:45:33","date_gmt":"2019-04-27T12:45:33","guid":{"rendered":"https:\/\/www.nico-maas.de\/?p=2045"},"modified":"2019-04-15T14:55:48","modified_gmt":"2019-04-15T12:55:48","slug":"migrate-sonarqube-from-mysql-to-postgresql","status":"publish","type":"post","link":"https:\/\/www.nico-maas.de\/?p=2045","title":{"rendered":"Migrate SonarQube from MySQL to PostgreSQL"},"content":{"rendered":"

For checking the quality of my private programming code, I have been using the free edition of SonarQube<\/a> for multiple years. It is actually a cool project with a massive flaw: They did allow to use MySQL as Database - but not MariaDB. This struggle kept me a bit at bay, as I parted with MySQL years ago - with this one exception.<\/p>\n

Some days ago I then stumbled upon the anouncement of SonarQube that did not fix this long-standing issue, but will be parting completly from MySQL<\/a>. So the only choice would be to migrate to Oracle, MS SQL or PostgreSQL.<\/p>\n

They even provided a tool called mysql-migrator<\/a> for this purpose. However, this did not work. It always kept on complaining that it could not detect the schema version, etc.<\/p>\n

Long story short: If you want (or in my case must...) switch from MySQL to PostgreSQL, use pgloader, which is available as Ubuntu package - all infos here<\/a>.<\/p>\n

I just installed a fresh PostgreSQL 9.6 in Docker, bundeled it with the postgres 9.6 alpine, fired it up and then migrated it with the following command:<\/p>\n

pgloader mysql:\/\/<mysqluser>:<mysqlpassword>@<mysqlserverip>:3306\/sonar pgsql:\/\/<psqluser>:<psqlpassword>@1<psqlserverip>\/sonar<\/pre>\n
Due to all things Docker, one had to play a bit around with the correct IPs, Ports and permissions to get the tool working, but once that was said and done, everything worked fine:<\/p>\n
                    table name       read   imported     errors      total time\n------------------------------  ---------  ---------  ---------  --------------\n               fetch meta data        180        180          0          0.357s\n                Create Schemas          0          0          0          0.001s\n              Create SQL Types          0          0          0          0.004s\n                 Create tables        106        106          0          2.842s\n                Set Table OIDs         53         53          0          0.015s\n------------------------------  ---------  ---------  ---------  --------------\n            sonar.active_rules       1993       1993          0          0.116s\n  sonar.active_rule_parameters        268        268          0          0.107s\n             sonar.ce_activity          1          1          0          0.074s\n      sonar.ce_scanner_context          0          0          0          0.040s\n           sonar.ce_task_input          0          0          0          0.025s\n     sonar.analysis_properties          0          0          0          0.157s\n      sonar.duplications_index          0          0          0          0.020s\n                  sonar.events        349        349          0          0.173s\n                  sonar.groups          2          2          0          0.330s\n             sonar.group_roles         12         12          0          0.433s\n                sonar.ce_queue          0          0          0          0.033s\n                  sonar.issues       7508       7508          0          1.546s\n sonar.ce_task_characteristics          0          0          0          0.029s\n       sonar.default_qprofiles          9          9          0          0.162s\n                sonar.es_queue          0          0          0          0.143s\n            sonar.file_sources        500        500          0          1.733s\n        sonar.loaded_templates         13         13          0          1.498s\n                 sonar.metrics        246        246          0          1.564s\n           sonar.organizations          1          1          0          1.744s\n           sonar.org_qprofiles         26         26          0          1.722s\n   sonar.perm_templates_groups          4          4          0          1.724s\n            sonar.groups_users          3          3          0          1.283s\nsonar.perm_tpl_characteristics          0          0          0          1.673s\n                sonar.projects        542        542          0          1.850s\n     sonar.internal_properties          2          2          0          1.384s\n           sonar.issue_changes        501        501          0          1.522s\n         sonar.manual_measures          0          0          0          1.306s\n           sonar.notifications          0          0          0          1.297s\n    sonar.organization_members          2          2          0          1.504s\n           sonar.project_links          0          0          0          1.532s\n    sonar.permission_templates          1          1          0          1.453s\n       sonar.project_qprofiles          0          0          0          1.483s\n    sonar.perm_templates_users          0          0          0          1.417s\n        sonar.qprofile_changes       2001       2001          0          1.616s\n                 sonar.plugins         13         13          0          1.366s\n     sonar.qprofile_edit_users          0          0          0          1.545s\n        sonar.project_branches          3          3          0          1.356s\n sonar.quality_gate_conditions          4          4          0          1.353s\n          sonar.rules_metadata       1763       1763          0          1.311s\n        sonar.project_measures      35940      35940          0          1.792s\n          sonar.rules_profiles         26         26          0          1.503s\n       sonar.schema_migrations        495        495          0          1.369s\n                   sonar.users          3          3          0          1.497s\n             sonar.user_tokens          5          5          0          1.489s\n              sonar.properties          8          8          0          0.941s\n    sonar.qprofile_edit_groups          0          0          0          0.924s\n           sonar.quality_gates          1          1          0          0.834s\n                   sonar.rules       1866       1866          0          1.069s\n        sonar.rules_parameters        278        278          0          1.021s\n       sonar.rule_repositories         21         21          0          0.999s\n               sonar.snapshots        280        280          0          1.047s\n              sonar.user_roles          0          0          0          0.960s\n      sonar.webhook_deliveries          0          0          0          0.942s\n------------------------------  ---------  ---------  ---------  --------------\n       COPY Threads Completion          4          4          0          3.049s\n                Create Indexes        127        127          0         22.308s\n        Index Build Completion        127        127          0          1.460s\n               Reset Sequences         33         33          0          0.051s\n                  Primary Keys         51         51          0          0.051s\n           Create Foreign Keys          0          0          0          0.000s\n               Create Triggers          0          0          0          0.001s\n              Install Comments          0          0          0          0.000s\n------------------------------  ---------  ---------  ---------  --------------\n             Total import time      54690      54690          0          8.412s\n<\/pre>\n
 <\/p>\n