2. PHPRunner General questions
  3. migrate from Mysql to Oracle
This topic is locked

migrate from Mysql to Oracle

 		10/31/2009 5:06:20 AM
PHPRunner General questions
J
 jccanut author

Hi,

Sorry for my english.

I'm using version 5.1 2503.

I've got a project using Mysql and I want to migrate it on Oracle.

Iv'e created tables and columns on Oracle with the same name.

When I open my old project, I try to change connection but it still use mysql connection.

Is there a way to avoid recreating all the application?

I know i will have to get changes but if I could retrieve most of the application it would be so great.

Thanks for your help.
JC
D
 		danaci 11/2/2009

open your projectname.phpr with notepad

edit customize
<m_nDatabaseType>0</m_nDatabaseType>

<m_strConnectInfo1>localhost</m_strConnectInfo1><m_strConnectInfo2>root</m_strConnectInfo2><m_strConnectInfo3></m_strConnectInfo3><m_strConnectInfo4></m_strConnectInfo4><m_strConnectInfo5>ithalat</m_strConnectInfo5><m_strConnectInfo6></m_strConnectInfo6><m_strConnectInfo7>1</m_strConnectInfo7><m_strCharset>windows-1254</m_strCharset><m_nCodepage>1254</m_nCodepage><m_bCreateLoginPage>1</m_bCreateLoginPage>

<m_nLoginMethod>1</m_nLoginMethod>

<m_strUserName></m_strUserName>

<m_strPassword></m_strPassword>

..

<m_strConnectionString>mysql;localhost;root;;;dbname;;1</m_strConnectionString>

..
J
 		jccanut author 11/2/2009

Many thanks for your response i will try it quickly.



open your projectname.phpr with notepad

edit customize
<m_nDatabaseType>0</m_nDatabaseType>

<m_strConnectInfo1>localhost</m_strConnectInfo1><m_strConnectInfo2>root</m_strConnectInfo2><m_strConnectInfo3></m_strConnectInfo3><m_strConnectInfo4></m_strConnectInfo4><m_strConnectInfo5>ithalat</m_strConnectInfo5><m_strConnectInfo6></m_strConnectInfo6><m_strConnectInfo7>1</m_strConnectInfo7><m_strCharset>windows-1254</m_strCharset><m_nCodepage>1254</m_nCodepage><m_bCreateLoginPage>1</m_bCreateLoginPage>

<m_nLoginMethod>1</m_nLoginMethod>

<m_strUserName></m_strUserName>

<m_strPassword></m_strPassword>

..

<m_strConnectionString>mysql;localhost;root;;;dbname;;1</m_strConnectionString>

..