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

Forums / Deployment / moving from mssql to mysql

moving from mssql to mysql

9 posts, 0 answered
  1. kmv
    kmv avatar
    7 posts
    Registered:
    29 Apr 2008
    03 Jan 2010
    Link to this post

    i want to swap a site from Ms to MYSql .. are all the tables 1-1 mapped .... any ideas on the easiest way to achive this



    thanks
    kevin
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    04 Jan 2010
    Link to this post
    Hello kmv,

    Thank you for using our services.

    Sitefinity does not provide tools for database migration. For these purposes you will have to utilize a third party tool for converting from one DB type to another. A Sitfinity DB does have a lot of stored procedures which will be automatically created once you connect your DB to the website. Otherwise there should not be any problems.

    Regards,
    Radoslav Georgiev
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  3. kmv
    kmv avatar
    7 posts
    Registered:
    29 Apr 2008
    04 Jan 2010
    Link to this post
    Radoslav


    thanks for the reply ... i am using the MySql tools to migrate the data, And yes the procedures get created when i create the site, should all the tables exist and be the same on both versions of sitefinity . I seem to be gettign tabel errors, particularly tables missing on the MySql installation.


    kevin
  4. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    04 Jan 2010
    Link to this post
    Hi kmv,

    Yes the all tables should be migrated (complete table structure) to the new DB. What kind of errors are you getting? Can you show us a stack trace?

    Regards,
    Radoslav Georgiev
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  5. kmv
    kmv avatar
    7 posts
    Registered:
    29 Apr 2008
    04 Jan 2010
    Link to this post


    My question is ... Are all the tables in a MSSQL installation also in a MYSQL install. The errors are on the migration where some tables in the MSSQL dont appear to be in the MYSQL database.

    Should the table list be identical ?


    thanks
  6. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    04 Jan 2010
    Link to this post
    Hi kmv,

    The tables should be the same. I attached a screenshot that represents which tables you should have on your MySql Server and SQL server as well.

    Best wishes,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  7. kmv
    kmv avatar
    7 posts
    Registered:
    29 Apr 2008
    04 Jan 2010
    Link to this post


    my mysql schema has only been created with 62 tables so quite a few missing , are all the tables created at site creation time or do some get created during run


    thanks
    kevin
  8. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    04 Jan 2010
    Link to this post
    Hi kmv,

    You may have 62 tables if you have never accessed the backend with the database you are trying to convert. Sitefinity supports MySql, so I am actually not sure why you would try to convert this database.
    Once you access the backend you should have 91 tables. After you create a content item another five tables will be created so the total number is 96.

    All the best,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  9. Shumaker Jill
    Shumaker Jill avatar
    1 posts
    Registered:
    23 Feb 2010
    23 Feb 2010
    Link to this post
    I think you should use a data migration tool , because when i was migrated my database i use a tool called Dbload and its very simple to use.

    Find Here :  http://www.dbload.com
Register for webinar
9 posts, 0 answered