Ruby on Rails Sunday, March 10, 2019

Just the schema. For the data, you'd need to run a backup utility of some sort. On MySQL, there's mysqldump, I'm pretty sure there's similar on the Postgres side, so no matter which direction you want to go, you'd be set. Be sure to only dump the data, not the structure, if you're using the schema:dump technique. Rails' database adapters are smart, and they can do the exact same structure with all the local weirdnesses that are required by the respective engines.

Walter

> On Mar 10, 2019, at 5:58 AM, Rob Jonson <rob.jonson@gmail.com> wrote:
>
> bundle exec rails db:schema:dump
>
> does this dump the data, or just the schema?
>
> I would assume just the schema - and that to transfer the data you'll need to use something like the solutions here:
> https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL
>
> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
> To post to this group, send email to rubyonrails-talk@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/5fcb6342-219a-41d8-882b-1ada28ffff8d%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/E0E67B86-7DB3-4CBC-9C50-8B867F7ACAD6%40wdstudio.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment