[Ruby] Converting mysql to postgres

[Corey Jewett]

Depending on how much effort you want to put into the conversion you  
could build Og versions of your models, setup connections to both dbs  
and walk all the models.

http://nitroproject.com/wiki/pages/Programming+Og/Documentation

Easier would probably be to write some regexs and do some sub!s.

Of course, if Eric has a script already rolled that'd be mighty  
handy. :)

Corey


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.
>
> Any ideas?
>
> Thanks,
> Joe
> _______________________________________________
> Ruby at zenspider.com
> http://www.zenspider.com/seattle.rb
> http://www.zenspider.com/mailman/listinfo/ruby