Re^2: Looking to convert all my MySQL DB's to postgresql, any experiences with mysql2pgsql? (sqlt)

Of course, the schema conversion part is a tad difficult if you're not familiar with postgres's data types.

sqlt / http://sqlfairy.sourceforge.net/ *magically* converts from schemas to schemas

sqlt -f MySQL -t PostgreSQL  < in.mysql > out.postgresql 
sqlt --from MySQL --to PostgreSQL  < in.mysql > out.postgresql 
sqlt --parser MySQL --producer PostgreSQL  < in.mysql > out.postgresql
[download]

Comment on Re^2: Looking to convert all my MySQL DB's to postgresql, any experiences with mysql2pgsql? (sqlt) Download Code

Replies are listed 'Best First'.
Re^3: Looking to convert all my MySQL DB's to postgresql, any experiences with mysql2pgsql? (sqlt) by taint (Chaplain) on Nov 27, 2013 at 14:33 UTC
LOL Funny you bring that Module up. After posting this topic, I went on a hunt to see if there might be something better, and landed on exactly that same Module. Thanks :) --Chris #!/usr/bin/perl -Tw use Perl::Always or die; my $perl_version = (5.12.5); print $perl_version;	[reply]