Getting error while migrating Sonarqube data from MYSQL DB to Postgresql DB

[ashaikh15 (Arbaz Shaikh)]

We have already tried the steps mentioned in the following doc

Failing update from 6.7.7 to 7.9.1

Hm, I found out that some tables are in public schema and some in other schema. I moved all tables to public schema by: DO LANGUAGE plpgsql $body$ DECLARE l_old_schema NAME = 'other schema'; l_new_schema NAME = 'public'; l_sql TEXT; BEGIN FOR l_sql IN SELECT format('ALTER TABLE %I.%I SET SCHEMA %I', n.nspname, c.relname, l_new_schema) FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = l_old_schema AND c.relki…