mysql database vs mssql server

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
cali_dotcom
Forum Commoner
Posts: 49
Joined: Fri Aug 22, 2008 7:28 pm
Location: Rancho Cucamonga, CA

mysql database vs mssql server

Post by cali_dotcom »

hi, i am currently building an application that depends on a third party application written in .net using a mssql server database. i am more of a lamp guy and prefer mysql. to extend the application i would need to add some tables to the database. i am currently thinking of creating my custom tables in mysql instead of adding new tables to the mssql db. i currently have to use free tds to communicate with the mssql da and that creates some challenges. is it better to leave the third party application alone using free tds to communicate with it and then create a new mysql db for my tables or to just have all data in one database, namely mssql, and just use free tds to communicate with all data? i would have to write an api to communicate with the db and also prefer to have this in php rather than .net.
x_mutatis_mutandis_x
Forum Contributor
Posts: 160
Joined: Tue Apr 17, 2012 12:57 pm

Re: mysql database vs mssql server

Post by x_mutatis_mutandis_x »

cali_dotcom wrote:hi, i am currently building an application that depends on a third party application written in .net using a mssql server database. i am more of a lamp guy and prefer mysql. to extend the application i would need to add some tables to the database. i am currently thinking of creating my custom tables in mysql instead of adding new tables to the mssql db. i currently have to use free tds to communicate with the mssql da and that creates some challenges. is it better to leave the third party application alone using free tds to communicate with it and then create a new mysql db for my tables or to just have all data in one database, namely mssql, and just use free tds to communicate with all data? i would have to write an api to communicate with the db and also prefer to have this in php rather than .net.
Is there any relational dependency between the tables you are adding and the tables existing in your sql server db? If so, it's better you add tables to the sql server db so you can normalize them. If there is no relationship, and the data in your app doesn't require normalization with the tables in your sql server, go for mysql DB. Either ways, when you code it in PHP, look into PDO as it supports multiple drivers to connect to different DB platforms.
User avatar
tr0gd0rr
Forum Contributor
Posts: 305
Joined: Thu May 11, 2006 8:58 pm
Location: Utah, USA

Re: mysql database vs mssql server

Post by tr0gd0rr »

If I were your successor, I would prefer to have all the data in one place. I imagine a DBA would feel the same way. Even if there was no data in the MSSQL server, I can't think of a compelling reason to use MySQL if you have a MSSQL server all ready to go.

MySQL is arguable a bit easier to manage for novices, but I assume you already have a DBA for your MSSQL server.
Post Reply