Book a Demo

Author Topic: Generate Package DDL error  (Read 2275 times)

pstein

  • EA User
  • **
  • Posts: 44
  • Karma: +0/-0
    • View Profile
Generate Package DDL error
« on: May 23, 2008, 08:28:16 am »
Assume I have a package defined with some "XSDcomplexTypes" in it.
I can succesfully create e.g. an XSD schema from it.

Now I want to create a DDL for a SQL database.

When I mark the package, right click and choose "Generate Package DDL" a dialog pops up. When I select now "Individual file for each table" and click "Generate" an error prompt appears:

Please select at least one table from the list!"

BUT: there is NO table it the list box below.

How can I otherwise select a table or generate DDL?

When I check "Single file" instead of "Individual file for each table"
what kind of file do I have to select in this case?

Peter

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Generate Package DDL error
« Reply #1 on: May 23, 2008, 09:12:17 am »
DDL generation and XSD generation happen from separate data.  So EA is quite right in not listing anything in the list.

I would recommend looking at transformations so that you can generate both models from a single source.  EA includes both DDL and XSD transformations that you can customize to your needs.