Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Eamesy on March 25, 2010, 07:50:51 am

Title: DDL generation for SQL - Schema other than dbo?
Post by: Eamesy 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

Title: Re: DDL generation for SQL - Schema other than dbo
Post by: hd 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.

Title: Re: DDL generation for SQL - Schema other than dbo
Post by: pocketom 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.

Title: Re: DDL generation for SQL - Schema other than dbo
Post by: Eamesy 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.

Title: Re: DDL generation for SQL - Schema other than dbo
Post by: RoyC 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.