The setup this needs is:
- Postgres 9.5
- with mysql_fdw installed
- database.yml
- postgres database as default
- mysql database as "source"
Start console, load the file ("load './convert.rb'") and you should be good to
go.
> On Feb 5, 2016, at 7:41 , Ryan Felton <[email protected]> wrote:
>
> Guyren,
>
> Interesting approach. Could you provide more detail in the setup and
> execution of this script?
>
> It looks like it uses some ActiveRecord database configuration. Is this run
> within a Rails app?
>
> For the destination database (postgresql) is there a connection thats needed
> or does this output as a sql script?
>
> Thanks,
>
> Ryan Felton
> 816.591.6257
> [email protected] <mailto:[email protected]>
> http://www.linkedin.com/in/ryanfelton <http://www.linkedin.com/in/ryanfelton>
>
>
> On Fri, Feb 5, 2016 at 2:36 AM, Guyren Howe <[email protected]
> <mailto:[email protected]>> wrote:
> I mentioned briefly in the meeting tonight that I'd used the new IMPORT
> FOREIGN SCHEMA command in Postgres to import a MySQL database with some
> success.
>
> The new command makes interacting with another database (MySQL, Oracle,
> Couch, Mongo, you name it) more or less as if it was just part of the local
> database.
>
> Anyway, the script is here:
>
> <http://relevantlogic.com/2016/02/04/converting-mysql-to-postgresql.html
> <http://relevantlogic.com/2016/02/04/converting-mysql-to-postgresql.html>>
>
> If anyone makes use of it, or wants to improve it, please let me know, or
> post it here.
>
> --
> --
> SD Ruby mailing list
> [email protected] <mailto:[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 <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.
