# SQL queries in another DB

**URL:** <https://www.ruby-forum.com/t/sql-queries-in-another-db/92240>\
**Category:** Rails\
**Created:** [April 17, 2007, 11:59am UTC](https://www.ruby-forum.com/t/sql-queries-in-another-db/92240 "2007-04-17T11:59:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Radu\_S](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ec9cab/32.png) [@Radu\_S](https://www.ruby-forum.com/u/Radu_S)\
**Post date:** [April 17, 2007, 11:59am UTC](https://www.ruby-forum.com/t/sql-queries-in-another-db/92240/1 "2007-04-17T11:59:49Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Radu\_S](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ec9cab/32.png) [@Radu\_S](https://www.ruby-forum.com/u/Radu_S)\
**Post date:** [April 17, 2007, 2:13pm UTC](https://www.ruby-forum.com/t/sql-queries-in-another-db/92240/2 "2007-04-17T14:13:05Z")

</div>

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