|
From: Miguel G. <mig...@ya...> - 2023-08-23 07:05:37
|
Hi, I know officially it´s not supported the migration of h2 database of sonarqube to postgresql but I am playing around to see if that´s possible after I read this thread: How to convert H2Database database file to MySQL database .sql file? | | | | | | | | | | | How to convert H2Database database file to MySQL database .sql file? I have some data in H2Database file and I want to convert it to MySQL .sql database file. What are the methods I... | | | I followed the suggestion and used Squirrel-SQL to try to migrate from H2 to PostgreSQL. For comparing the outputs I have setup three Sonarqube 8.9.10 LTS instances: 1) a Sonarqube instance with H2 with historical data of past scans. 2) a Sonarqube instance with PostgreSQL with just one scan. 3) Another instance of Sonarqube with PostgreSQL with the data migrated from instance 1. That way using Squirrel-SQL I can compare and see if there is any difference. I can see the data has been copied, primary keys, imported and exported key and indexes have been copied too. I have enabled debug mode in Sonarqube to see If I see any error from any query. The curious thing is that there is some data Sonarqube can display like individual projects but not list all projects in the dashboard. Any suggestion of what I should look at or how I could compare both PostgreSQL databases to see where the issue might be? Thanks again, Miguel |
