dreamweaver CS5 php mysql Vs asp.net MSsql for windows environment
Posted on 2010-08-23
Ok heres the deal our current intranet built in asp.net VB using dreamweaver 8 hosted on IIS6 with MSsql datsbase. All users in IE browser.
Then we upgraded to Dreamweaver CS5 (so alot had changed) including the absence of support for asp.net :O(
From a dreamweaver point of view it makes sense to me to move across to php (the site is due a rebuild anyway) but is this a poor decision for a windows environment?
It would seem logical to still host on IIS6 using the FastCGI for php particularly as we will want to use the integrated windows authentication to identify intranet users without login.
The choice between MSSQL & MySQL seems a little less clear, given that we already have a sql server is there any advantage in using MySql other than its the normal choice for php, I was leaning that way because all thesupport etc is geared towards the php Mysql combination but now I'm beginnning to doubt the wisdom of that decision when my own familiarity leans to MSSQL.
As mentioned it must be possible to pick up user id without login this is particularly important now as the intention is to rebuild the site in a way that enables users to fully customise their pages. Other than that it will require an admin site and the ability to give certain users rights to different parts of that with the ability to upload docs and post items etc - fairly standard stuff.
Appreciate any feedback on the use of php over .net in a windows environment and any pros con re database and hosting options.
Many thanks in advance