Book a Demo

Author Topic: Import DB Schema from ODBC - MYSQL  (Read 1960 times)

CLX

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Import DB Schema from ODBC - MYSQL
« on: March 04, 2009, 09:35:43 am »
Hi,

After import my MySQL Database via ODBC MySQL Driver 5.1, the Primerykey (PK) is not displayed in the diagrams, but the Primerkey definition is set:

Code: [Select]
<<column>>
*   id: BIGINT = PRI
*FK fk_language_id: BIGINT = MUL

<<PK>>
+   PK_test(id:BIGINT)

What do I need to change, so that looks like this after a new import from ODBC MySQL (without manual changes)?

Code: [Select]
<<column>>
*PK id: BIGINT = PRI
*FK fk_language_id: BIGINT = MUL

<<PK>>
+   PK_test(id:BIGINT)

Thanks
« Last Edit: March 04, 2009, 09:36:17 am by CLX »