Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

Migration of Parasoft DTP DB from MySQL to Postgres

guyam
guyam Posts: 5 ✭
in DTP

I have to migrate the Parasoft DTP DB from on-prem MySQL to Postgres on Azure.

Are the step by step instructions?

I'm trying:
pgloader --type mysql "mysql://root:@uc-tlv-prod-pstdb-01:3306/DTP" "postgresql://psqladmin:@parasoft-devex-postgres.postgres.database.azure.com/DTP"

getting the error:
025-03-25T09:56:57.014000-04:00 LOG pgloader version "3.6.70f3557"
2025-03-25T09:56:59.316000-04:00 LOG Migrating from #
2025-03-25T09:56:59.316000-04:00 LOG Migrating into #
2025-03-25T09:56:59.445000-04:00 ERROR mysql: Failed to connect to mysql at "uc-tlv-prod-pstdb-01" (port 3306) as user "root": MySQL Error [1045]: "Access denied for user 'root'@'uc-tlv-prod-pstdtp-01.iha.eup.gm.com' (using password: YES)"
2025-03-25T09:56:59.446000-04:00 LOG report summary reset
table name errors rows bytes total time

fetch meta data 0 0 0.000s

Also,

Succeeded login with
psql "postgresql://psqladmin:@parasoft-devex-postgres.postgres.database.azure.com/postgres?sslmode=require"

any idea what I'm missing?

Comments

  • JeehongMin
    JeehongMin Posts: 44 ✭✭

    We do not have any instructions on migrating data from one database type to another. Unfortunately, this is not a supported use case.

    The migration is theoretically possible, but we are not able to provide any assistance.

Categories