How to copy data from mysql to postgres?

Rails
1

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

2

On Mon, Jan 14, 2013 at 6:06 AM, Fahim P. [email protected] 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.

3

On 14 January 2013 12:06, Fahim P. [email protected] wrote:

Hi all,

Is there any gem to copy data from mysql to postgres ?
I search lot but i didn’t get any thing .

Converting MySQL to PostgreSQL - Wikibooks, open books for an open world 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

4

use gem taps

2013/1/14 Colin L. [email protected]

–
Rodrigo M.
(62) 8567-3142

5

Thanks lot for reply.

Fahim

6

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

7

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

8

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 ?