I've cloned a cloud site that has recently had Engage added to it. The Cloud clone wants to use the default SQLLite for the DB, but immediately errors with

System.ApplicationException: Umbraco Engage does not support SQLite!

. I want to use an empty LocalDB SQL instance instead, but I'm struggling to work out the config I need to get it all linked up. I'm possibly missing something obvious, so any pointers would be welcome

@Matt Bliss I was able to setup this locally. Once you are done setting up local db using sql management studio, you need to add connectionStrings database info to your appsettings.json file. Build/run the project and you should be good to go. Hopefully this helps

Hi @Daisy157, thanks so much for the tip, I'm really pleased you got it all working! Actually I had configured the connection string, it turns out the problem I was having wasn't a config one, I'd basically got that part right. In my case it was a hardware/software conflict. Macbook Pro with Apple Silicon, Parallels and SQL Server, is not a combination that play nicely together. I got there eventually though!