The issue we run into during the migration process, is about foreign keys.
There are a lot of Constraints, created from on database version 68.
You find statements like this:
ALTER TABLE iwa_role ADD FOREIGN KEY (SecurityMemberId) REFERENCES IWA_SecurityMember(SecurityMemberId);
In some rare cases these statements can be executed successful, but in most it won't.
With quite little changes, the alter statements can be brought in a state, where they execute well.
This is how:
ALTER TABLE iwa_role
ADD **CONSTRAINT {add_unique_name_here}**
FOREIGN KEY (SecurityMemberId) REFERENCES IWA_SecurityMember(SecurityMemberId);
But this approach seems a bit heavy, copy all statements and add unique constraint names to each alter foreign key query. Are there any ideas for a work around, from the community or AxoinIvy supporters?
