How should I handle using two databases with a legacy PHP application?

Posted by Toby Allen on Programmers See other posts from Programmers or by Toby Allen
Published on 2012-07-03T21:41:01Z Indexed on 2012/07/04 3:22 UTC
Read the original article Hit count: 282

Filed under:
|
|
|

I have a legacy PHP application that was written in 2004 and uses MSSQL as a database backend.

At this stage MSSQL is still supported by PHP but only just via a Microsoft driver. I have looked at converting to mysql via automated tools, which work quite well, but I have quite complex views which need a lot of individual work to convert. I don't have a great deal of time to do this.

Many tools I wish to use and frameworks I would like to move the application to, don't support MSSQL, so I was considering adding new features using a new mysql database and wondered if anyone had opinions on the pros and cons of using two seperate database backends in a single application?

© Programmers or respective owner

Related posts about php

Related posts about database