Re: Quick question MySQL --> PgSQL

"Brett W. McCoy" wrote:
> 
> On Tue, 6 Mar 2001, Josh Berkus wrote:
> 
> >       Just a quick question ... I need to do a regular transfer (daily + on
> > demand) of data from a MySQL database to a PostgreSQL database and back
> > again.  Can anybody steer me towards a good script for this, or do I
> > have to write my own in PHP?
> 
> Don't think there is an actual migration script (I could be wrong,
> though), but a program using Perl DBI or JDBC would make the data access a
> bit easier -- if you wrote it generically enough, you could make the data
> transfer go both ways with just a command-line switch.
> 
> -- Brett
>                                 http://www.chapelperilous.net/~bmccoy/
> ------------------------------------------------------------------------
> Give all orders verbally.  Never write anything down that might go into a
> "Pearl Harbor File".
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



there is one in contrib

as well there is some through freshmeat.net