Kenny Katzgrau has a recent post on the Code Fury blog talking about the combination of CodeIgniter, IIS, MySQL and MSSQL and how it all works in his installation (after a few small gotchas).
There are a lot of people out there who call themselves "LAMP" developers - short for Linux, Apache, MySQL, PHP. That's the standard configuration for production PHP applications. Recently, I ended up having to build a CodeIgniter application on Windows, IIS, Mysql+MS-SQL, and PHP. Sound like there are bound to be issues? You bet, and it especially hurts because now I'm a real-live WIMP developer. And what made it even more interesting was that due to constraints, I had to develop the application in Ubuntu and deploy to Windows for production.
He includes the list of the "gotchas" that he came across when doing the installation - six of them:
- PHP and MSSQL on Ubuntu
- PHP and MSSQL on Windows
- mssql vs. sqlsrv
- File Permissions and Logging
- No .htaccess Fo' You!
- 2 Databases, 1 Application