Book a Demo

Author Topic: Having trouble updating model from database  (Read 2154 times)

Sql Server DBA

  • EA Novice
  • *
  • Posts: 14
  • Karma: +0/-0
    • View Profile
Having trouble updating model from database
« on: July 11, 2008, 04:32:10 am »
I'm running into challenges keeping the model in synch with the database.  Database is SQL Server 2005, EA 6.5...

Sometimes I have to re-import a table three or four times to get all the FK's to show up.  Or delete the table, and re-import it, requiring me to update numerous drawings.

What's the best practice here?  Keep re-importing over and over until it works?  

Thanks

Sql Server DBA

  • EA Novice
  • *
  • Posts: 14
  • Karma: +0/-0
    • View Profile
Re: Having trouble updating model from database
« Reply #1 on: July 11, 2008, 05:09:17 am »
Update EA is slowly eating my model.

If I re-import a table to get changes, I get two of them in Project Browser.

Some tables now when put on a diagram refuse to display any of thier Foriegn keys.

Diagrams I haven't touched are missing things.

Is this normal?