Walter Davis wrote in post #1028614: > On Oct 26, 2011, at 9:15 AM, pololo pololo wrote: > >>>> Is it possible to sqlite and mysql coexists in same RoR app? >>> >> try other approach? > I haven't needed to do it myself yet (actually working on something that > will need this) but I have seen many tutorials on the Web related to > connecting a single Rails application to multiple databases. It is just > as simple as you say, make a production_1 and production_2 database > connection, and use them through the base classes to set up the > appropriate targets for your queries. > > But what I suspect may be even easier here is for you to use something > like Sinatra to create a very simple API endpoint wrapping around the > legacy database, and then send requests through that API from your Rails > application. It doesn't sound to me (you did mention SQL queries, after > all) as if you actually need that other database to become an > ActiveRecord model store. > > Walter
This solved my question: http://stackoverflow.com/questions/80859/in-rails-how-do-i-execute-direct-sql-code-on-a-different-database Thanks a lot for your time Walter P -- 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 post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
