Re: Quick question MySQL --> PgSQL - Mailing list pgsql-sql

From clayton cottingham
Subject Re: Quick question MySQL --> PgSQL
Date
Msg-id 3AA530D1.47E532AF@smartt.com
Whole thread Raw
In response to Re: Quick question MySQL --> PgSQL  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Responses Re: Quick question MySQL --> PgSQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Quick question MySQL --> PgSQL
Next
From: dev@archonet.com
Date:
Subject: Re: Quick question MySQL --> PgSQL