SQL queries in another DB

Hi,

I need to insert SQL data in another database used by a PHP program
from rails. Any ideas how I can do this?

  • Radu

If you can get the data in a CSV, YAML or even XML format, you could
write a rake task to do this, and then just fire off the rake task
with a runner.

I only suggest this as I gather that the rails app is already
connected to a different database, and you don’t want to connect rails
to two databases(although you can)

Cam