Perhaps you can use rails to read the data from mysql, write it out a file (maybe in a JSON format? one line per record?). Then in another rails process, connected to postgres, write that data back out.
Xavier > On Apr 23, 2019, at 4:52 PM, Ylan Segal <[email protected]> wrote: > > On Tue, Apr 23, 2019 at 1:44 PM Peter Fitzgibbons > <[email protected] <mailto:[email protected]>> wrote: > Hello folks, > > I having a really rough time migrating a mysql 5.6 db to postgres 10.5. > > How large is your data set? Can you tolerate downtime? > > It's hard to give advice without knowing more. The simplest I can think of is > exporting to CSV and importing to the other database. It would probably mean > importing without foreign_key constraints and then adding them later. > > Have tried all these tools with no success: > * pgloader > * pg_chamelion (can't even get it started... someone have a how-to ?) > * Multiple scripts from the official pg docs : > https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL > > <https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL> > > What didn't work with these approaches? > > -- > -- > SD Ruby mailing list > [email protected] > http://groups.google.com/group/sdruby <http://groups.google.com/group/sdruby> > --- > You received this message because you are subscribed to the Google Groups "SD > Ruby" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby --- You received this message because you are subscribed to the Google Groups "SD Ruby" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
