Book a Demo

Author Topic: Data Model-Multiple table relationships  (Read 3244 times)

kepNCI

  • EA User
  • **
  • Posts: 127
  • Karma: +1/-0
    • View Profile
Data Model-Multiple table relationships
« on: April 29, 2014, 01:22:06 am »
I assume this is a bug.
1) Create a new data model package and diagram, then Import DB Schema from ODBC. Viewed the results in the diagram.
2) Without making any changes in diagram, re-execute the Import DB Schema from ODBC.  Expected to not see any changes. For most relationships that was true, but for a few, there was a second relationship created between the two tables, thus creating a false duplicate relationship.
3) Again, without making any changes in diagram, re-execute the Import DB Schema from ODBC. Again, most relationships remain the same, but for the few that had the duplicate relationship created, either a third relationship was added or the duplicate was removed.
4)If you keep re-executing the Import DB Schema from ODBC, the relationships with the above issues would either just keep adding additional relationships or would toggle deleting and adding the additional relationship.    

Has anyone seen this and if so can explain what is going on?

In my case the database being modeled is an MS SQL 2008 R2.