Hmmm--well I'd have a look at ActiveResource then. My understanding is that it gives a local, scriptable interface (one that's very ActiveRecord-esque) on remote rails apps via REST webservice type calls. I think the theory is that you get a remote-accessible automation interface on your rails app for the price of abiding by the various RESTful conventions that rails likes so much. But someone should check me on that--I don't have any direct experience w/it myself.
Anyhoo--if that's not too far wrong, and assuming the overhead of the underlying HTTP calls isn't too horrible to endure, I'm thinking you could make DBI connections to your local mssql db, read stuff into memory, and then push the data to your remote app via the ActiveResource objects. Cheers, -Roy On Thu, Mar 4, 2010 at 12:25 PM, Daniele <[email protected]> wrote: > Hi Roy, > actually I have a rake task in my RoR app that connect to a remote > MSSQL database and import data. This task use dbi with a quite complex > system configuration. > Because I cannot use it on Heroku it could be nice to setup the Heroku > database as remote one on a second installation so I can use the > migration task to push the data. > > On 4 Mar, 21:12, Roy Pardee <[email protected]> wrote: > > Is it a rails app? If so, maybe a ruby script using the ActiveResource > > library would work for you? > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<heroku%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. > > -- Roy Pardee http://facebook.com/rpardee -- You received this message because you are subscribed to the Google Groups "Heroku" 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/heroku?hl=en.
