1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / Migrating from MSSQL to MySQL

Migrating from MSSQL to MySQL

2 posts, 0 answered
  1. Marwan
    Marwan avatar
    2 posts
    Registered:
    08 Nov 2007
    15 Jan 2008
    Link to this post
    we creat Sitefinity on development computer using MS-SQL-Express and on hosting we only have SQL. what we need to do to migrate to My SQL

    Thanks for any hep
  2. Vlad
    Vlad avatar
    498 posts
    Registered:
    19 Jun 2017
    15 Jan 2008
    Link to this post
    Hello Marwan,

    The main point is to migrate the database from SQL Server to MySQL. Probably you could find a tool for this on the Internet.
    As for the Sitefinity changes, you should only modify the connection string and change the Nolics data providers in the dataAccess section in the web.config:

    ... 
    <dataAccess defaultConnection="DefaultConnection"
          <connections> 
            <add name="DefaultConnection" driver="Telerik.DataAccess.MySQLProvider, Telerik.MySQLProvider" 
              connectionStringName="Sitefinity" /> 
            <add name="GenericContentConnection" driver="Telerik.DataAccess.MySQLProvider, Telerik.MySQLProvide" 
              connectionStringName="Sitefinity" /> 
          </connections> 
    ... 

    The upcoming release will provide another solution.You will be able to export the site as a Site Template (actually not the whole site, but only pages and content) and import it in another site.

    Hope this helps.


    Sincerely yours,
    Vlad
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
2 posts, 0 answered