It happened to me a few times that the logical of the attributes were lost in a physical model. I have not tried to reproduce the bug from scratch, but here are some operations I did (not necessarily in order):
- Reverse engineer a DB.
- Do some updates to it.
- Do a model update from the DB.
- Generate an alter script.
- The application crashed on a few occasions.
-> When I started the application and loaded the model at one point, all attribute logical names of FK were back to the name of the field in the parent table (like “ID” rather that “WhateverID” that I had renamed it to when creating the FK). The attribute physical names were still “WhatverID”. The sync was lost.
I have not found a way to fix this automatically in the application, so I had to start from scratch.
Anyone else noticed something similar?