Changing database type to Azure SQL from Sqlite

Questions
1

I posted this question but didn’t really get a response. However i did get an idea from posting to stackoverflow which said I maybe need to host my database using an Azure SQL database. Is there an easy way to do this with an existing project? or is it easier to create a new project and move models and views over?

2

I’d use uSync. So you can just have an empty SQL database and import everything using uSync. Thats how we work. Development is done on SQL localDB, every other environment uses SQL Server.

2 Likes
3

Thanks for this info. However, since creating my own stuff on azure was going to be way too expensive, I’ve opted to use Umbraco cloud. I simply made a new project and just copied all my code and settings over into the cloud project. Anywhere I used explicit media/folder ID’s in the .cshtml I’ve ensured are from that environment, however I still am geting a 500… :smiley:

I am able to access my projects backoffice however

4

From discord.. Discord
Might be that you can script the sqllite db schema and text from sqlLite/sqlce compact toolbox and run against sqlServer?
SQLite Toolbox Extension for Visual Studio
SQLite and SQL Server Compact Toolbox - Visual Studio Marketplace

5

It turned out to just be issues with views etc that seemed okay locally but not on the cloud. I’ve resolved issues now. Umbraco cloud seemed to be a better option than hosting on Azure directly, and cheaper!

Thanks, the info you gave is still helpful

6

Interresting. Cloud is absolutely a good choice, but I have never EVER considered it cheaper than hosting it on Azure ourselves. Maybe we get certain discounts, but cloud is absolutely more expensive in our case.

7

Really? Maybe I set up wildly over priced plans for my needs. I chose a low tier which was something like £60 per month, plus I had to add to the plan to use my custom domain. I then looked at created the database in Azure and was looking at upwards of £400 for it. It definitely seemed off, but if it was going to be that difficult to even work out a decent subscription then it was just as easy to go to Umbraco cloud and pay the £36 per month.

This is a very small website so it’s the lowest Umbraco cloud subscripton. Do you mind giving an overview of your Azure environment?

8

Might be of use a little old and you can run v9+ on linux now to shave a little more off.
How to host a simple Umbraco site in Azure as cheap as possible | mattou07

Also New Azure SQL Database free offer - Azure SQL Devs’ Corner might be able to get away with it…

9

But if its really a very low traffic simple site, why not just run from sqllite of sql local db and skip the sql server database all together?

You might even get away with running an azure web app B tier on Linux, thats cheaper (it doesnt support sql local db, only sqllite)