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
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