[CODE4LIB] mysql to postgres

2007-08-15 Thread Eric Lease Morgan 

Can anybody here recommend a MySQL database schema to Postgres
database schema converter?

I have a (MyLibrary) MySQL database schema. Do y'all know of some
sort of script I can run against this text file to create a Postgres
database schema?

--
Eric Lease Morgan
University Libraries of Notre Dame

Re: [CODE4LIB] mysql to postgres

2007-08-15 Thread Hilmar Lapp 

SQL::Translator (written in Perl) does this.

http://sqlfairy.sourceforge.net/

   -hilmar

On Aug 15, 2007, at 2:28 PM, Eric Lease Morgan wrote:


Can anybody here recommend a MySQL database schema to Postgres
database schema converter?

I have a (MyLibrary) MySQL database schema. Do y'all know of some
sort of script I can run against this text file to create a Postgres
database schema?

--
Eric Lease Morgan
University Libraries of Notre Dame


--
===
: Hilmar Lapp  -:-  Durham, NC  -:- hlapp at duke dot edu :
===

Re: [CODE4LIB] mysql to postgres [resolved]

2007-08-15 Thread Eric Lease Morgan 

On Aug 15, 2007, at 2:32 PM, Wayne Graham wrote:


Check out SQLFairy (http://sqlfairy.sourceforge.net/)



On Aug 15, 2007, at 2:40 PM, Hilmar Lapp wrote:


SQL::Translator (written in Perl) does this.

http://sqlfairy.sourceforge.net



Yep, SQLFairy, or specifically sqlt, seems to work just fine. Thank you!

--
Eric Morgan