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


  • Hugh Loughrey 5 posts 46 karma points
    May 31, 2015 @ 06:58
    Hugh Loughrey
    0

    Installing Umbraco Workflow?

    Hey so i've been having a bit of play with umbraco for a few months, I've built a website using the default SQL CE datbase file...but now I would like to upgrade this to SQL Express. 

    Can someone confirm the steps required to undertake this? From a bit of reading I get the impression the steps are meant to be something along the lie of:

     

    1. Create new empty ASP.NET MVC 4 web application;
    2. Install Umbraco via package manager;
    3. Under developer section add Export SQL Server Compact;
    4. Export database schema and data using Export SQL Server Compact;
    5. Within SQL Server management Studio create a new database for new website;
    6. Run database schema export script against newly created database
    7. Change connectionString setting within Web.config 

    From: 

        <add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0" />

    To:

        <add name="umbracoDbDSN" connectionString="Server=<SERVER_NAME>;Database=<DATABASE_NAME;Integrated Security=true" providerName="System.Data.SqlClient" />
    From reading around these seem to be the rough steps to follow, but if I follow these steps, my dummy website crashes. Can someone confirm that these are the correct steps to follow to migrate Umbraco 7.2 from SQL CE to SQL Server Express?
    Thanks
    Hugh

     

    Copy Link
  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    May 31, 2015 @ 11:19
    Dennis Aaen
    0

    Hi Hugh,

    The easy way of doing this is to install Webmatrix since it really makes it a bliss to migrate the database from CE SQL to MSSQL - I have done it many times. You can download it here http://www.microsoft.com/web/webmatrix/

    If you click the database tab in the program then you will get a overview of you database in the solution that you have open. If you see this article you will see there is a migation button. http://www.microsoft.com/web/webmatrix/database.aspx. You just need to click this, and it will do the job for you.

    The only thing you need to do is to change connectionString setting within Web.config, from something like this

    <add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0" />

    To:

    <add name="umbracoDbDSN" connectionString="Server=<SERVER_NAME>;Database=<DATABASE_NAME;Integrated Security=true" providerName="System.Data.SqlClient" />

    Hope this helps, and make sense.

    /Dennis

    Copy Link
  • Hugh Loughrey 5 posts 46 karma points
    Jun 01, 2015 @ 11:21
    Hugh Loughrey
    0

    Hi Dennis,

    Thanks for the reply...but I was hoping to avoid webmatrix as I've had no end of difficulty with it in the past. Is started throwing IIS errors and not opening projects etc.

    Can you outline the workflow you'd follow outside of webmatrix?

    Cheers

    Hugh

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft