Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Yoni 49 posts 118 karma points
    Jul 28, 2014 @ 17:54
    Yoni
    0

    Convert my site from SQL CE to regular MSSQL? Umbraco 7

    I created my site in 7 using SQL CE. It is almost ready to go live. I have seen there a few plugins that only work with ms SQL and not CE. Is there any way to convert my site without building it from scratch?

    Thanks

    Copy Link
  • Sebastiaan Janssen 5061 posts 15544 karma points MVP admin hq
    Jul 28, 2014 @ 19:19
    Sebastiaan Janssen
    100

    Easy, open the site in WebMatrix, go to Database, click Umbraco.sdf, click Migrate and put in your SQL server credentials. enter image description here

    Copy Link
  • Yoni 49 posts 118 karma points
    Jul 28, 2014 @ 19:24
    Yoni
    0

    Thanks

    Then what settings do I need to change in Umbraco to point it there?

    Copy Link
  • Sebastiaan Janssen 5061 posts 15544 karma points MVP admin hq
    Jul 28, 2014 @ 19:58
    Sebastiaan Janssen
    0

    Connectionstring umbracoDbDsn, I think it gets updated automatically when you do this.

    Copy Link
  • Yoni 49 posts 118 karma points
    Jul 29, 2014 @ 08:21
    Yoni
    0

    I would like to add my experience.

    I used the Migrate option in WebMatrix. I did not need to create the DB in advance, Webmatrix did it for me.

    When the process was done, I was left with 2 connections strings. The original one and the new SQL which got the name "Umbraco". I deleted the original one and renamed the new one to "umbracoDbDSN" and everything worked great.

    But thanks, you did get me most of the way there.

    Copy Link
  • philw 99 posts 434 karma points
    Apr 26, 2015 @ 13:18
    philw
    0

    Thanks, you just saved my life with that. Notres:

    • Can't download Webmatrix using Chrome, but IE works ok.
    • WebMatrix 3 works as you suggest - you have to double click the DB entry to get the "migrate" option to show up.
    • I migrated straight to a remote hosted DB. I had only 15 pages to shift but it took a good 10 minutes even so, with not much progress report. If you had a big migrate it may take a while, or you could migrate it to a local SQL Express (which WebMatrix offers to install for you). and then backup/ restore it.

       
    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies