Author Topic: DDL generation for SQL - Schema other than dbo?  (Read 1752 times)

Eamesy

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
DDL generation for SQL - Schema other than dbo?
« on: March 25, 2010, 07:50:51 am »
I am using SQL 2008 and using EA to maintain and script a new data model using DDL script generator. The script it creates always has extented properties of "dbo" as the schema owner whereas I want to reflect a custom schema owner like the package name. This way the SQL script generates creates tables like "Security.User" rather than "dbo.User" in my db
Can't see this anywhere in Help....
Any suggestions?

Thanks

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: DDL generation for SQL - Schema other than dbo
« Reply #1 on: March 25, 2010, 07:56:12 am »
EA should generate a schema other than dbo, if you add the owner tagged value to the table.
http://www.sparxsystems.com/uml_tool_guide/data_modeling/settableowner.html

If it doesn't, I suggest you submit a bug report using the link below.

pocketom

  • EA User
  • **
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: DDL generation for SQL - Schema other than dbo
« Reply #2 on: March 26, 2010, 03:02:33 am »
Thanx, works fine! Perhaps EA should offer a standard field somewhere (e.g. in tab Table Detail beside 'Table Space'...). Would it make easier to find.

Eamesy

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: DDL generation for SQL - Schema other than dbo
« Reply #3 on: March 26, 2010, 08:17:13 am »
Thanks HD, works for me too, I agree with Pocketom's comments. At least add it in the help file index somewhere! Hope others find this helpful.

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1297
  • Karma: +21/-4
  • Read The Help!
    • View Profile
Re: DDL generation for SQL - Schema other than dbo
« Reply #4 on: March 26, 2010, 08:57:15 am »
I have added permutations of 'Schema Owner' to the index entries for that topic. The changes should be visible in the Help for the next release of EA.
Best Regards, Roy