Sparx Systems Forum

Enterprise Architect => Suggestions and Requests => Topic started by: jasonab on July 12, 2005, 11:49:03 am

Title: Sync database model with DB
Post by: jasonab 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?

Title: Re: Sync database model with DB
Post by: thomaskilian 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.