9 Apr
2011
9 Apr
'11
6:14 a.m.
On Fri, 8 Apr 2011 19:02:23 -0400, Brad Chapman <chapmanb@50mail.com> wrote:
Louise-Amélie;
I just met a huge problem concerning the database. I'm currently trying to transfer my data from MySQL to PostgreSQL by writing a Perl script that would do the job.
I've used this ruby script to convert a Galaxy MySQL database to PostgreSQL:
https://github.com/maxlapshin/mysql2postgres
and it worked smoothly. But definitely be safe and take a backup before messing with the database so you can roll back to MySQL if you have any issues.
Brad
Oooh interesting :) thank you! I don't really like Ruby but meh, why not after all. I still hope I'll be able to make my script work though, since it's almost complete, but I'm keeping your solution too. Cheers, L-A