Copied to clipboard

Flag this post as spam?

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


  • Genc Kastrati 62 posts 306 karma points
    May 27, 2019 @ 12:13
    Genc Kastrati
    0

    Cloud > localhost using SQL Server on Azure instead of SQLCE

    Hi everyone,

    Did a quick search on the forum for this but couldn't find something specific to the following: We are using Umbraco Cloud and are very happy with it, and I have the localhost doing restore from the DEV server. It uses SQLCE of course.

    Does anyone know if it is possible to instead use SQL on Azure and not rely on SQLCE? Would this be even possible to do a restore from DEV if using SQL on Azure?

    Thank you! Genc

  • Søren Kottal 442 posts 2736 karma points MVP c-trib
    May 27, 2019 @ 12:16
    Søren Kottal
    1

    It is, if you change the connectionstring in your local web.config to point at the SQL server of choice, then it will restore to that.

    But - don't share the DB with other devs, they need to have their own! You will run into all kinds of problems and mismatches if you do.

  • Genc Kastrati 62 posts 306 karma points
    May 27, 2019 @ 12:18
    Genc Kastrati
    0

    Thank you Soren! Yes good point. Fortunately I am alone :D I will give it a try with changing the connection string. Thank you !

  • Matthew Wise 198 posts 828 karma points c-trib
    May 27, 2019 @ 12:43
    Matthew Wise
    1

    Hi

    Cloud actually uses local dB if you look for the usual SDF file you will notice it's missing and replaced with a MDF if I recall correctly. Fair warning if you open it with SQL studio the site stops working till you restart something to release it

    Matt

  • Genc Kastrati 62 posts 306 karma points
    May 27, 2019 @ 14:13
    Genc Kastrati
    0

    Thank you Matthew. I guess SDF has been dropped for version 8?

    Good to know about blocking!

  • Matthew Wise 198 posts 828 karma points c-trib
    May 27, 2019 @ 15:29
    Matthew Wise
    0

    CE still works. Cloud just doesn't use it :)

Please Sign in or register to post replies

Write your reply to:

Draft