today I wanted to upgrade an application. But the database migration failed. The database is from 2007 and has been migrated to a higher version accordingly many times, so inconsistencies are likely.
I have now created a raw database for the same original version to find out where the problem is.
According to the software error message, it seems to be a rights problem.
What was also apparent is that the raw database has primary keys and foreign keys in the respective tables. In the database to be migrated, no primary keys and foreign keys are defined. Could this be the cause?
How would you proceed? Would you store the primary keys and foreign keys now afterwards, or rather move the content from the respective tables into the raw database? For this, however, I would have to deactivate the foreign key check, otherwise the insert would fail.
I am looking forward to your suggestions!