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
    0

    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" />
    

    to

     <add name="umbracoDbDSN" connectionString="server=10.181.136.59;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 ?

    Thanks,

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

    Hi Fuji,

    What you can do is migrate the database to SQL Server. To do that, you can use this Visual Studio extension: https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1

    Cheers, Cristhian.

  • 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