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


  • 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

    Copy Link
  • 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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft