1043 Posts in 379 Topics by 373 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 1270 Views |
-
Migrating Windows, SilverStripe 2.4.2 and MySQL -> SQL Server?
23 October 2010 at 1:53pm
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!
-
Re: Migrating Windows, SilverStripe 2.4.2 and MySQL -> SQL Server?
24 October 2010 at 12:48pm Last edited: 24 October 2010 12:52pm
You should be able to move the whole project directory over to the new server, and instead of using SQL Server, just install MySQL instead.
If you've already got the database in MySQL, there's no need to move to SQL Server, and it'll probably be headaches and more work to migrate MySQL databases to SQL Server anyway.
Cheers,
Sean -
Re: Migrating Windows, SilverStripe 2.4.2 and MySQL -> SQL Server?
24 October 2010 at 12:58pm
Thanks Sean - will give it a go!
-
Re: Migrating Windows, SilverStripe 2.4.2 and MySQL -> SQL Server?
8 March 2012 at 4:30am
Sorry to hijack.
Sean, i have the exact opposite problem.
Weve started the site on IIs SQL and need to migrate to Apache mySQL.
Can someone successfully convert an SQL DB to mySQL DB?
If so, how to do that?
Any help appreciated.
Thanks!
| 1270 Views | ||
|
Page:
1
|
Go to Top |
