Copied to clipboard

Flag this post as spam?

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


  • Brendan 5 posts 25 karma points
    Jul 29, 2011 @ 10:07
    Brendan
    0

    Upgrading SQL CE 4 to MSSQL

    Hi Guys

    I hope someone can help.

    I've build a website using SQL CE i've been using webmatrix, now I need to upgrade to MSSQL, is there any easy way to do this, webmatrix has a migrate button under the database section to migrate it, but it requires a username and password, No database username and password is required when setting up a SQLCE, It is now asking for a username and password but I don't have one.

    Please can someone help

    Thanks
    Brendan

  • Ben Norman 167 posts 276 karma points
    Nov 18, 2011 @ 01:53
    Ben Norman
    0

    Hi Brendan,

    Yep, there is a very easy way to do this. Pushing the button you pushed and updating the connection string in the web config is all you have to do.

    So get yourself a database on an MSSQL instance somewhere and a username and password that can connect to it.

    Then push the migrate button again and use the username password you got your hands on.

    Then update the web.config / appsettings / umbracoDbDSN item with "server={what ever your mssql instance name is};database={the database name};user id={the username};password={the password}"

    If you need to install MSSQL then use the Microsoft Web Platform installer.

    Regards

  • 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