A client of mine has decided to upgrade their server to Windows Server 2008 w/ IIS 7.5 . I have already set up the site on their old enviroment which was Server 2003 and IIS 6 using IIRF as an URL Rewriter.
I've noticed that the latest installation instructions for SilverStripe on Windows reference SQL Server instead of MySQL. Does anyone have any experience using the latest version of SilverStripe 2.4.2 with MySQL on Windows? Or conversely.. have any experience migrating a prior version of a SilverStripe database from MySQL to SQL Server?
Any thoughts on the best way to handle this migration? Should I stick with the MySQL database? Are there any special configuration directives I need to know to modify the current installer to set up the upgraded site to use MySQL?
Should I reinstall SilverStripe and move mysite, themes and any extensions/themes/modules over as-is or move the entire filesystem over?
Any thoughts are welcome!