Migrating from MySQL to PostgreSQL

Some time back I migrated to MySQL.
However, I personally prefer to use PostgreSQL, so my question is:

Is there any way to migrate the data (including history) from a MySQL database to a PostgreSQL database?

I tried subverting the HSQL2MySQL utility for this, specifying the mysql database as source and the postgres database as target, but it failed with the message:

Tue Feb 05 15:18:33 CET 2008 Connecting to the source database jdbc\:mysql\://localhost/teamcity3
Exception in thread "main" java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at jetbrains.buildServer.serverSide.HSQL2MySQL.main(HSQL2MySQL.java:64)

I am including the mysql driver jar in the path.


Maarten

3 comments

Maarten,

At the moment migration tool does not support other migration directions other then HSQLDB -> MySql. We are adding the support for other directions and it will hopefully be available in TeamCity 3.1 that should be released this month.

--
Best regards,

Yegor Yarko
Project Manager
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"

0

Thanks Yegor,

I'll looking forward to that then.
Are you planning any EAP releases for 3.1?

Regards,

Maarten

0

Maarten,

Right now we are working on letting an EAP build out. Hopefully, one of these days...

--
Best regards,

Yegor Yarko
Project Manager
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"

0

Please sign in to leave a comment.