how to copy data from mysql to postgres?

[Fahim Patel]

Hi all,

Is there any gem to copy data from mysql to postgres ?

I search lot  but i didn't get any thing .

Thanks 

Fahim

[Jordon Bedwell]

On Mon, Jan 14, 2013 at 6:06 AM, Fahim Patel <paf...@gmail.com> wrote:
> Is there any gem to copy data from mysql to postgres ?
> I search lot but i didn't get any thing .

You're gonna have to figure that one out yourself by using 2 models
and some clever trickery, or you might be able to dump the data and
import into postgres if it's generic enough with little effort but I
would much rather go the 2 model route even if it takes far more time.

[Fahim Patel]

Thanks lot for reply.

Few months ago i have studied about one gem which do this work, but i forget the name.

Did any one know about this ?

[Colin Law]

On 14 January 2013 12:06, Fahim Patel <paf...@gmail.com> wrote:
>
> Hi all,
>
> Is there any gem to copy data from mysql to postgres ?
> I search lot but i didn't get any thing .

http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL describes
how to do a dump from mysql and restore to postgres but I don't see
any advantage of using a gem over that technique.

Colin

[Rodrigo Mendonça]

use gem taps

2013/1/14 Colin Law <cla...@googlemail.com>

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonra...@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Rodrigo Mendonça
(62) 8567-3142

[Fahim Patel]

Thanks lot for reply.

Fahim

[Walter Lee Davis]

I really like yaml_db for this. I have only used it for SQLite to MySQL and MySQL to MySQL, but it works smoothly and quickly, and in my case, did not flinch at 2M records in a table.

Walter

> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To post to this group, send email to rubyonra...@googlegroups.com.
> To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.

> To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/a7BZJWbsdq8J.

[akalyaev]

I would like to add: if you have some custom mapping between the models, you could write a simple rake task. Example: http://myutil.com/2008/8/31/rake-task-transfer-rails-database-mysql-to-postgres

Regards,

Anton