move database from mssql to postgresql

[nico8948]

I'm trying to move the database from mssql to postgresql. What 1've done: export the mssql tables into csv files. Created a new postgresql database, change the connection string from mssql to postgresql. Restart the dependeny track. The postgres tables are filled the vanilla data, the application is working. When trying to import de csv file (converted to sql file) starting with with PROJECT table with all related files doesn't show the projects. My questions, is it possible? and anyone has experience?

[nscuro]

There's no pre-built migration script or anything. Before I became maintainer, around the v3.8 -> v4 migration, I used pgloader to migrate from MySQL to PostgreSQL.

I documented what I did here: https://gist.github.com/nscuro/1d32c6099a8a82f98f737fffa936b416#file-instructions-md

But by now it will be horribly out-of-date, of course. But maybe it helps anyway.

Note that we will provide migration scripts from the currently supported RDBMSes to PostgreSQL when Dependency-Track v5 reaches general availability. v4 will continue to support MSSQL.