Author Topic: Sync database model with DB  (Read 2447 times)

jasonab

  • EA Novice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Sync database model with DB
« on: July 12, 2005, 11:49:03 am »
Right now, EA can sync its database diagram with the state of the database, but I would love to be able to go in the other direction.

Hopefully, if I then change a column name (or add a constaint), EA will issue the appropriate ALTER commands to the database to put it in the proper state. Has this been discussed at all?

thomaskilian

  • Guest
Re: Sync database model with DB
« Reply #1 on: July 13, 2005, 03:44:29 am »
That goes into the direction of RR's database engineer. To do what you want, EA needs to be statefull. I could imagine an add-in to do the job. However, it's not only ALTER but also DROP which is more difficult for sure. Since once you delete a table, EA doesn't have any information. So I guess, EA will not be the tool for database maintenance. Except you put in a lot of work by writing an add-in.