Hi All

I've had a brilliant solution form Craig100 and some huge help from Umbraco HQ I am so grateful for all of this

Here's a good article from Paul Seal on how to migrate your SQLCE DB to SQL Express. He's got loads of other useful tutorials and videos there as well ;)

https://codeshare.co.uk/blog/how-to-convert-sql-server-compact-edition-sdf-to-full-sql-and-speed-up-umbraco/

There's also SQLToolBox: https://stackoverflow.com/questions/39305498/how-do-i-upgrade-umbraco-cms-from-using-sql-server-ce-to-an-upgraded-version Thanks David

Craig

The Help Fro Umbraco HQ was also amazing and is clearly a Solution that's been tested Thank you Jakob!

Hey, I made it work! You would have to DL the tool from: https://github.com/ErikEJ/SqlCeToolbox then get your SDF ready, and in windows CMD prompt run ExportSqlCE40.exe "Data Source=D:\Repo\Umbraco.sdf;Persist Security Info=True" database.sql and that will generate SQL scripts for the DB. You might need to download https://www.microsoft.com/en-us/download/confirmation.aspx?id=30709 too. Alternatively if you send me the SDF I can do that for you 👍

Best

Resolved

is working on a reply...