Author Topic: Foreign Key Associations didn't import from ODBC  (Read 125 times)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 5882
  • Karma: +71/-78
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Foreign Key Associations didn't import from ODBC
« 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

Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Richard Freggi

  • EA User
  • **
  • Posts: 43
  • Karma: +1/-1
    • View Profile
Re: Foreign Key Associations didn't import from ODBC
« Reply #1 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)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 5882
  • Karma: +71/-78
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Foreign Key Associations didn't import from ODBC
« Reply #2 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
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!