RoR 4 - Connection to multiple databases

[Quake Live]

Hi there,

is it somehow possible to connect from a running Rails4-app to another
database?

My problem is that I have to transfer records from a table from the main
database to a different database.

--
Posted via http://www.ruby-forum.com/.

[Walter Lee Davis]

On Sep 29, 2015, at 5:04 AM, Quake Live <li...@ruby-forum.com> wrote:

> Hi there,
>
> is it somehow possible to connect from a running Rails4-app to another
> database?

Yes, I have done this in the past for migration reasons. You can create a different connection "long-hand" and get a specific model to use it. The last answer on this page (sadly zero-rated) has the solution I used. http://stackoverflow.com/questions/12379730/query-remote-database-from-rails-3-2-application

Walter

>
> My problem is that I have to transfer records from a table from the main
> database to a different database.
>
> --
> Posted via http://www.ruby-forum.com/.
>

> --
> 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-ta...@googlegroups.com.
> To post to this group, send email to rubyonra...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/af0507fdd791af43902e56204e028af5%40ruby-forum.com.
> For more options, visit https://groups.google.com/d/optout.

[jel...@gmail.com]

I actually ran into this same use case a couple of months back and using class abstraction did the trick beautifully.

Sent from my iPhone

> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/099545A9-E6B4-443B-9041-37430D3A486C%40wdstudio.com.

[Stewart Mckinney]

Try https://github.com/atombender/multidb as well. Very simple DSL and can be used for this stuff.

To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/0AE5D12E-CC4A-44D6-877C-92D18E3EE92F%40gmail.com.