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
Please sign in to leave a comment.
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!"
Thanks Yegor,
I'll looking forward to that then.
Are you planning any EAP releases for 3.1?
Regards,
Maarten
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!"
any changes nowdays?
we also need to migrate teamcity database from mysql to postgres. What is the best practice to achive this?
Hi Dmitry,
you can follow the steps described here for migrations between any of the supported database systems: https://www.jetbrains.com/help/teamcity/migrating-to-an-external-database.html
You might want to check the notes on setting up your database first here: https://www.jetbrains.com/help/teamcity/setting-up-an-external-database.html
Thanks,
migrated without problem