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?
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
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
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.
Thank you Soren! Yes good point. Fortunately I am alone :D I will give it a try with changing the connection string. Thank you !
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
Thank you Matthew. I guess SDF has been dropped for version 8?
Good to know about blocking!
CE still works. Cloud just doesn't use it :)
is working on a reply...