3.7 to 4.1

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

Why are you using BACPAC ?

Your database is 3.7
You need to run the upgrade script 3.7 to 3.8
Then need to run the upgrade script 3.8 to 3.9
Then need to run the upgrade script 3.9 to 4.0
Then need to run the upgrade script 4.0 to 4.1

An easy answer to that. I wanted to take a BACPAC at each stage before running the next one.

Perhaps from what you are saying I can copy the upgraded database as a new database each time..

However that does not answer why it is saying that my schema is not Azure? I don't understand the error message I'm getting when I am not yet on an Azure DB schema.