problems importing Foreign Keys from ODBC

[Geert Bellekens]

I'm using EA v14.1.1427 and SQL Server 2016.

After renaming a foreign key things go wrong when trying to import the changes into EA

Steps to reproduce:
- Import a simple test database with two tables and a foreign key between them
- Change the name of the foreign key in the database
- Show differences in the database builder
- Set Import All
- Import from ODBC

Notice that the fK relation has lost it's properties and it now a simple association with stereotype «FK» with no name or assigned columns.

Then
- Import DB Schema from ODBC again with the option to synchronize everything.
- This brings back the foreign key (with the new name) but still leaves the broken FK association in the model.

The result of this all then looks like this:


Reported to Sparx

Geert