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


  • 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,

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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft