Re: Mysql to Postgresql converter

On Fri, Jan 25, 2013 at 03:10:53PM -0800, Fred Moyer wrote:
> Hello,
>
> I've been fighting a Mysql database recently, and the few tests I've
> run so far have shown a significant query performance improvement with
> a mysql database table that was converted to PostgreSQL.
>
> So I'm wondering if anyone knows of a magical program that I can hand
> my database credentials to, go get a cup of coffee, and come back to
> Postgresql database which was migrated from the Mysql database. I've
> seen a few Rails based conversion utilities on Github, but I'd prefer
> a command line application.

Fred,

Automated solutions go from about 40% to 80% for the general case, but
not much higher, for reasons I am starting to believe have to do with
the fundamentals of computing. There's a proprietary thing from
EnterpriseDB that's supposed to be good, along with the open-source
things mentioned in this thread.

Are there a lot of things writing to the DB that need to be taken into
account? The FDW (foreign data wrapper) method works pretty well for
testing the read side in PostgreSQL, and allows you to use pretty
simple ways to import once you've done that testing.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate