Umbraco Cloud Local SQL server | Umbraco | Page 1

thick valley Sep 20, 2023, 6:35 PM

#

I have a cloud site running locally and I need to do a large import. The performance is terrible when the import is running. I think it’s due to SQLite. Is it possible to use SQL Server instead? If so how?

kindred rain Sep 20, 2023, 7:19 PM

#

Absolutely. Just create yourself a DB as usual and change the connection string in the appsettings.Develop.json.

thick valley Sep 20, 2023, 7:59 PM

#

Great stuff. Thanks mate.

trail yarrow Sep 21, 2023, 9:27 AM

#

There is also a config setting you can put in your deploy appsettings, to prefer using LocalDB over SQLite

versed root Sep 21, 2023, 9:31 AM

#

^^ What Skttl said, assuming you have LocalDB installed, you can "simply" switch over to use that as the default instead.

Personally, I would like to see the code do what old Cloud used to do and switch to LocalDB if it finds it on the machine rather than a config setting 🙂

#Umbraco Cloud Local SQL server