Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: john.roome on September 16, 2003, 08:15:12 pm

Title: Database Schema Import doesn't pickup Foreign Keys
Post by: john.roome 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

Title: Re: Database Schema Import doesn't pickup Foreign
Post by: hd 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.  :(

Title: Re: Database Schema Import doesn't pickup Foreign
Post by: mogarick 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