2. PHPRunner General questions
  3. How to connect a project to 2 databases on 2 RDBMS
This topic is locked

How to connect a project to 2 databases on 2 RDBMS

 		4/5/2009 7:52:53 AM
PHPRunner General questions
hichem author

Hi admin,

I have 2 questions:
1- is it possible to connect a PHPR project to 2 RDBMS? Most of my reports/charts are based on MySQL database but I need to access an oracle database for a real time report. How can this be done in PHPR?
2- When migrating from development to a production environment, what file would I have to change to modify the database name and password (couldn't see where in dbconnections.php) assuming that my table names are the same between the 2 environments. Would all PHPR reports continue to work if I had a different database name between the dev and prod systems? (all my sql queries do not explicitly mention the database name)
Many thanks
Hich
J
 		Jane 4/6/2009

Hi,
please see my answers below:

  1. By default PHPRunner supports one database only. You can add a second database connection using events.
  2. Unfortunately there is no reliable way to convert PHPRunner project automatically. In general you should open project file in any text editor, edit all connection strings and SQL queries, events, database functions, etc.