# 1 application, 2 databases: 1 legacy db informix 1 Mysql db?

**URL:** <https://www.ruby-forum.com/t/1-application-2-databases-1-legacy-db-informix-1-mysql-db/119315>\
**Category:** Deployment\
**Created:** [November 5, 2007, 11:53pm UTC](https://www.ruby-forum.com/t/1-application-2-databases-1-legacy-db-informix-1-mysql-db/119315 "2007-11-05T23:53:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![malooking](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/77aa72/32.png) [@malooking](https://www.ruby-forum.com/u/malooking)\
**Post date:** [November 5, 2007, 11:53pm UTC](https://www.ruby-forum.com/t/1-application-2-databases-1-legacy-db-informix-1-mysql-db/119315/1 "2007-11-05T23:53:31Z")

</div>

Please, i need help.

i wonder if rail allows to have 1 legacy database in informix and other  
mysql database (no legacy) in the same application.

I need to query in the informix database and manipulate data to save in  
mysql.

It is posible?? it it is, how? any guide? tutorial? link?

I’ll appreciate any help.

best regards.

Mary,  
Baja California

Soon Baja 1000!

---

<div class="post-metadata">

**Author:** ![malooking](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/77aa72/32.png) [@malooking](https://www.ruby-forum.com/u/malooking)\
**Post date:** [November 14, 2007, 6:14pm UTC](https://www.ruby-forum.com/t/1-application-2-databases-1-legacy-db-informix-1-mysql-db/119315/2 "2007-11-14T18:14:46Z")

</div>

Wes has some good links to follow.

I personally am developing an app that uses about 100 databases of  
Firebird type, and a single MySQL database.

I manage the connections via a session variable which contains the  
current active DB and a method in my application controller to set the  
DB connection.

There are many ways to solve this problem, the best solution is going  
to depend on your situation.