On Tue, Apr 23, 2019 at 1:44 PM Peter Fitzgibbons < peter.fitzgibb...@gmail.com> 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 > What didn't work with these approaches? -- -- SD Ruby mailing list sdruby@googlegroups.com 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 sdruby+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
