Author Topic: Generate DDL for multiple tables at once  (Read 3311 times)

MikiNanuk

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Generate DDL for multiple tables at once
« on: August 24, 2004, 11:17:47 am »
We have modelled our data store in EA using the table stereotype.  Now we want to create DDL for SQL Server 2000.  The best method we have found is to individually right-click each table in the data model diagram and export to a file.

Is there a way to create the DDL for all tables in the data model with one action?

Thanks!

Eric

Bruno.Cossi

  • EA User
  • **
  • Posts: 803
  • Karma: +0/-0
    • View Profile
Re: Generate DDL for multiple tables at once
« Reply #1 on: August 24, 2004, 11:46:42 am »
Hi Eric,

you can just right-click on the package that contains your tables/classes, click on Code Engineering and Generate DDL.

Hope this helps!

Bruno

MikiNanuk

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Re: Generate DDL for multiple tables at once
« Reply #2 on: August 24, 2004, 01:21:11 pm »
Thanks!

We were looking for it to be in the top level of the context menu, like it is for individual tables.

Eric

Bruno.Cossi

  • EA User
  • **
  • Posts: 803
  • Karma: +0/-0
    • View Profile
Re: Generate DDL for multiple tables at once
« Reply #3 on: August 24, 2004, 03:35:00 pm »
You're welcome!
With EA, things are not always when one would expect them, but they are usually there :-)

Bruno