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?

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

Great stuff. Thanks mate.

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

^^ 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 🙂

Apart from when using Commerce/Vendr, I actually like SQLite. It's simple and fast. Having said that, I've never used LocalDB 😉