Author Topic: Database Schema Import doesn't pickup Foreign Keys  (Read 1082 times)

john.roome

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Database Schema Import doesn't pickup Foreign Keys
« on: September 16, 2003, 08:15:12 pm »
Hi,
I'm trying to import a database schema from a PostGres database into a data model.  It imports all the tables with their details except that it doesn't import the foreign key constraints.  

Details
Version 3.60.641 of EA
Version 7.03.01.00 of the PostGresQL ODBC driver

any help would be greatly appreciated

John

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Database Schema Import doesn't pickup Foreign
« Reply #1 on: September 17, 2003, 04:56:39 pm »
Unfortunately, the PostgreSQL ODBC driver does not yet support the ODBC API functions necessary to import foreign key constraints.  :(

mogarick

  • EA Novice
  • *
  • Posts: 12
  • Karma: +0/-0
    • View Profile
Re: Database Schema Import doesn't pickup Foreign
« Reply #2 on: October 13, 2003, 12:38:41 am »
Hi,
I'm having almost the same problems about foreign keys, but i´m using the MySQL ODBC Driver.

The problem i have is when i reverse engineer my DB.
EA just get one Foreign Key for each table  :(.

I though it was something wrong about my DB, because EA presented some dialogs warning me about repeated indexes.

But when I reverse engineer my DB in ERWin (i guess you know it) there weren´t any problems and all the foreign keys were in place.

Can anybody tell me why?  :-/

Another thing i was wondering is if there some way i can reverse engineer a DB model from an SQL Script.

Thank you for your help