Visio EA 2003 - Generating DDL - where did the owner attribute go?

[Dennis Redfield]

I am having trouble generating DDL statements for database models where the
target is SQL Server 2000. Speciffically if I have a table "Table 1" in the
model owned by "aic" the DDL generated does not include the owner attribute.
Thus we see:
create table "Table 1"
rather than
create table "aic"."table 1"
How can I correct this.
thanks.

dlr

 

[Al Edlund]

I believe that I may have seen a previous note/string that finally came to
the conclusion that his might be a sql server issue (something about it did
not like periods in the names).
al

 

[Dennis Redfield]

not sql servers problem. We actually LIKE periods in names:
table
owner.table
database.owner.table
server.database.owner.table

all are correct syntax. The question is why does the VISIO drivers (from MS
also) will not generate the correct DDL even when "owner" is defined in the
VISIO diagram.

thanks for playing


dlr

 

[Al Edlund]

I understand (I also use sql server, although I don't forward engineer using
visio).
al