Posts Tagged ‘postgreSQL

03
Oct
07

data migration from mysql to postgresql

Lately I had to move some data from mysql db to postgresql one. I was thinking that it’ll be nice & easy task, I couldn’t be more wrong. Obviously there’s no!? reliable migration tool from MySQL to PostgreSQL so for a not-pg person like me it wasn’t fun, not at all. OK, there’s PERL script on pgfoundry (wow, they even got their foundry ;) . It is marked as ‘mature’. I have to disagree. It doesn’t work. It helps a bit but it doesn’t. So, if you wanna migrate table structure with data be prepared, get pg documentation and expect troubles. It’s not *that* hard but will take more then 5 minutes, that’s for sure :)