[Ruby] Converting mysql to postgres

Ryan Davis ryand-ruby at zenspider.com
Sat Aug 5 16:54:57 PDT 2006


On Aug 5, 2006, at 1:22 AM, Joe Van Dyk wrote:

> Hi,
>
> Anyone got any cool tricks for converting a Rails site (in this case,
> a typo installation) from a mysql database to a postgresql database?
>
> I've got it almost working -- I'm doing a SQL dump from mysql and
> loading it into postgres.  However, mysql does booleans as a tinyint
> with 0 = false and 1 = true.  When I try to import that into a
> postgres database that expects booleans to be actual booleans, it
> fails.

Eric has a script to deal with this... I'm pretty sure he's able to  
share it.



More information about the Ruby mailing list