Migrating Orchard DB from MS SQL server to MySQL

Topics: Administration
Nov 11, 2013 at 5:12 PM

we are looking at a possible migration from MS SQL to MySQL, moving from shared hosting to dedicated server. I would like to ask if somebody had done this and if there are any gotchas that we should be aware of.

What I have in mind is to setup a local copy of the site to see if the schemas generated are identical and it works fine, then if so just clone the SQL server instance to the MySQL database, change the connection string in settings file and that's it. What else?
Nov 12, 2013 at 12:55 AM
It should be it in principle. I have never done it however so can't comment on possible caveats.
Jul 1, 2014 at 10:13 AM
It was as straight forward as stated above. Here is a link to a walk-through of completing the data migration. http://wp.me/p2FwEB-3