Quick question for those of you experienced with this... I am coding a site that is using MySQL and PHP. Works well, but I dislike interfacing with MySQL... I am experienced with SQL Server as I use it at work, but am a rookie with PHP. I know there are some aftermarket software programs you can buy for minimal cost to make it look like SQL Server's Management Studio, etc. but before I go there, I would like to stick with SQL Server and Management Studio, etc. My question is, what are the pros and cons with using MySQL vs. SQL Server with my PHP driven site? 2008 vs. 2012 make any difference? Every time I look up using PHP with SQL server, I get links that tell me I need to download additional drivers or Sql Server, etc.. and at first it appears as if it is NOT that simple switching everything over. Before I go through the process of trying to switch my site over to SQL Server and finding out it isn't as simple as changing the functions, database name, password, etc. , I would love to hear from so of you who have experience in this area who can confirm I should learn this or let me know if it is not that simple??
Is it as simple as changing the connection code in php from mysqli_connect to mssql_connect? (along with the corresponding path, dbase name, password, etc.)
Thanks, Chainsawal