Book a Demo

Author Topic: Generate DDL for altering tables  (Read 3300 times)

Daniel_J

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Generate DDL for altering tables
« on: December 15, 2010, 03:04:49 am »
Hi there

With the help of the generated DDL from my database model I have created some tables in my database.
Now I've changed some tables in EA and want to generate a DDL which updates the tables in my DB.
Is that possible?

I can compare the generated DDL with the current DB and there it suggests to ALTER some tables but when I generate the script, it wants to create new tables...

Thanks in advance

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Generate DDL for altering tables
« Reply #1 on: December 15, 2010, 07:51:40 pm »
Daniel, AFAIK EA doesn't generate alter scripts.

Geert

Daniel_J

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Generate DDL for altering tables
« Reply #2 on: December 15, 2010, 10:14:24 pm »
Okay, thank you.

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: Generate DDL for altering tables
« Reply #3 on: December 16, 2010, 06:31:15 am »
It would be an excellent new feature though
Orthogonality rules
Position and Team disestablished, thanks austerity.
Now itinerant.