Jump to:

1160 Posts in 2621 Topics by 409 members

Upgrading SilverStripe

SilverStripe Forums » Upgrading SilverStripe » Migrating Windows, SilverStripe 2.4.2 and MySQL -> SQL Server?

Ask questions about upgrading SilverStripe to the latest version.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 1607 Views
  • weareorganism
    Avatar
    Community Member
    14 Posts

    Migrating Windows, SilverStripe 2.4.2 and MySQL -> SQL Server? Link to this post

    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!

  • Sean
    Avatar
    Forum Moderator
    921 Posts

    Re: Migrating Windows, SilverStripe 2.4.2 and MySQL -> SQL Server? Link to this post

    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

  • weareorganism
    Avatar
    Community Member
    14 Posts

    Re: Migrating Windows, SilverStripe 2.4.2 and MySQL -> SQL Server? Link to this post

    Thanks Sean - will give it a go!

  • wilsonStaff
    Avatar
    Community Member
    142 Posts

    Re: Migrating Windows, SilverStripe 2.4.2 and MySQL -> SQL Server? Link to this post

    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!

    1607 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.