Copied to clipboard

Flag this post as spam?

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

  • Fuji Kusaka 2203 posts 4220 karma points
    Sep 19, 2016 @ 20:23
    Fuji Kusaka

    Moving sdf to SQL

    Hi guys,

    After creating a new project under UAAS and clone it on local server, i would like to move it to SQL instead of SQLce.

    I removed this line from my web.config

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


     <add name="umbracoDbDSN" connectionString="server=;database=dbName;user id=dbID;password=password" providerName="System.Data.SqlClient" />

    and used a connecting string where it returns a upgrade screen but is taking ages to load.

    Question would be am i doing the right thing ?


  • Cristhian Amaya 52 posts 423 karma points
    Sep 20, 2016 @ 12:21
    Cristhian Amaya

    Hi Fuji,

    What you can do is migrate the database to SQL Server. To do that, you can use this Visual Studio extension:

    Cheers, Cristhian.

Please Sign in or register to post replies

Write your reply to: