2. PHPRunner General questions
  3. changing database from mysql to mssql
This topic is locked

changing database from mysql to mssql

 		4/4/2007 4:48:43 AM
PHPRunner General questions
A
 amplus author

I wanted to change the database from mysql to mssql, i have a project in mysql and wil this also use for my new database in mssql.

Who can say what i must do to change the project.
V
 		Vladimir 4/4/2007

Open your project file (Project.phpr) in Notepad and edit following strings:

<m_nDatabaseType>0</m_nDatabaseType> change to <m_nDatabaseType>2</m_nDatabaseType>


<m_strConnectionString>mysql;...> change to <m_strConnectionString>mssql;Host Name;Login;Password;Database Name</m_strConnectionString>


<m_strDatabaseType>0</m_strDatabaseType>change to<m_strDatabaseType>2</m_strDatabaseType>


<m_cLeftWrap>'</m_cLeftWrap> change to<m_cLeftWrap>[</m_cLeftWrap>


<m_cRightWrap>'</m_cRightWrap> change to<m_cRightWrap>]</m_cRightWrap>


Then find and replace all backquotes (`) with square brackets. For example `example` -> [example].