Migrating From MS/IIS to Linux/Apache?

Mixhaus asks: "I'm trying to promote the Linux culture in my company. I want to migrate or at least start all new web projects on a Linux/Apache setup. Currently all the development is done on IIS/ASP with MSSQL 7.0. Has anybody done this kind of migration before? Any suggestions?"

"These are some of the questions that come up to my mind:

• Be able to migrate IIS to Apache first, and still be able to access the MSSQL databases (FreeTDS?)
• Use a scripting syntax similar to ASP so that the programmers don't have much of a headache learning new stuff (PHP looks like a solution).
• Migrate MSSQL 7 to MySQL, PostgreSQL or other (Which one is better for web development?)
• Web log reports (I need to generate reports on the web site usage. What weblog report generators are available for Linux? Which ones do you use? Are there any that generate graphs, charts, etc..?)

Thanks to the whole Slashdot Community!"