Sparx Systems Forum

Discussion => Automation Interface, Add-Ins and Tools => Topic started by: Paolo F Cantoni on November 24, 2017, 01:44:06 pm

Title: Foreign Key Associations didn't import from ODBC
Post by: Paolo F Cantoni on November 24, 2017, 01:44:06 pm
I just did my first DB schema import for a while (just two tables).  I ticked every option I could find on the import, but the Associations that represent the Foreign Key Constraints didn't import.  What did I do wrong?

IIRC, there used to be an option to show the FKs as Associations or not or is my memory failing me?

TIA,
Paolo

Title: Re: Foreign Key Associations didn't import from ODBC
Post by: Richard Freggi on November 28, 2017, 12:14:05 am
What RDBMS?  I reverse (and forward) engineer with SQLite using the OBDC driver mentioned in the user guide and my FKs and associations work.  EA 13.0.1310 on Win10)
Title: Re: Foreign Key Associations didn't import from ODBC
Post by: Paolo F Cantoni on November 28, 2017, 10:34:46 am
What RDBMS?  I reverse (and forward) engineer with SQLite using the OBDC driver mentioned in the user guide and my FKs and associations work.  EA 13.0.1310 on Win10)
SQL Server 2016.  The driver is marked as ODBC Driver 13 for SQL Server.

Paolo