DB Code Generation

[omian]

I had been using ERwin and Oracle Designer, but with this new project it is required of me to use EA for data modeling.

I was tryign to play around with it, howerer i could not figure out if it generates differential script for any data base. For instance I add a column to a table which already exists in the database. Designer used to log in to the database and check the table in the physical database and provide me with a script to only add that column to the table instead of creating the script for the whole table. Does EA has some similar functionality. If there is any could some one provide me with useful information on how to achieve that.

omian

[thomaskilian]

If there is, it must have come with 6.5. It has been asked in the past and Sparx had/has it on the hotlist. Maybe someone else can confirm that.

[Graham_Moir]

It's definitely being worked on but did not make 6.5
See

http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.pl?board=suggestions;action=display;num=1132585369

[omian]

Is there any work around for this process. I do see the genration of a drop statement, but when there exist to or from referentials it creates a problem.

Secondly would you advice EA for data modeling or should I stick to Oracle Designer, which itself is not the best tool for a SQL Sevrer database.

[thomaskilian]

The work around would be to save the generated DDLs in a versioning system and maintain the changes manually. Regarding the drop: it does not work by itself as you may have experienced. So manual intervention is required too.

Whether you should use Oracale Designer or EA depends on your requirements (see another recent thread here Rose/EA). If you're a pure DB designer you should probably use a tool like the OD or Erwin or the like. If you are more than just a DB designer and have a hand on the related applications, then EA would definitely be the tool of choice. But, of course, this depends.