This is not a straightforward task. I have the SQL scripts, etc.
I tried to manually change the data and to work around the schema changes, but IDs kept re-writing, breaking links, etc.
I have managed to perform a local upgrade of my copy of the 3.7 database to 3.8 however when I take a BACPAC I get an error:
Error SQL71627: The element Permission has property Permission set to a value that is not supported in Microsoft Azure SQL Database v12.
I am confused by this as I am working locally, not on Azure. I do not see why this would alter the schema unless v3.8 was designed to be online (Azure) only.
In which case do I need to create my further databases in the cloud? Surely not.
I need to upgrade to 4.1 and need this dealing with urgently. If you have an expert who can lend a hand, please get in touch.
Best regards,
Matthew