Presents: ObjectRoleModeling.com Thursday, September 09, 2010
  Search
Register Login
Forums
 
 

Note: To post to a thread, you must be logged in.

  Syndication  
   
  Forums Minimize  
 
 
ForumForumOrthogonal Tool...Orthogonal Tool...SupportSupportBugs DetectedBugs Detected
Previous Previous
 
Next
 Disabled
New Post
 10/1/2008 11:14 AM
 
 Modified By naskar  on 10/1/2008 11:54:23 AM
Hi!!

I´m testing your tool and I think it´s great!! My first tries included foreign keys and on cascade restrictions and everything was ok ;)

1.-   I get the script witout "return" so I have edit it in order to make it work properly...
For example, I get this script:
create table dbo.[Table2] () go create table dbo.[Table1] () go

and I have to replace with:
create table dbo.[Table2] ()
go
create table dbo.[Table1] ()
go


2.-  DataTypes:
   - smallint is recognised as SHORT (does not exist)
   - date is recognised as DATETIME instead of DATE
   - time is recognised as DATETIME instead of TIME



Can you help to fix them?

I´m using visio 2003, and explorer 7 to render the xml, very thanks !!!
Regards,
Ruben.
New Post
 10/1/2008 11:57 AM
 
Check out this blog post for some XSLT that is supposed to get around the line return problem.

http://blog.donnfelker.com/post/Simplifying-Database-Modeling-in-Visio-20022003-through-SQL-Generation.aspx


New Post
 10/2/2008 9:08 AM
 
Thanks Scot!

The new stylesheet fixed the line return problem.

Do you what can I do about the other issue? (smallint is exported as short)

thanks again ;)
New Post
 10/2/2008 5:55 PM
 
I don't have a copy of Pro installed, so I can't test this out (or walk you through the visio menu sommands), but the XSLT grabs the datatype you set within Visio. Try using a different driver for the DB.

Scot.
Previous Previous
 
Next
 Disabled
ForumForumOrthogonal Tool...Orthogonal Tool...SupportSupportBugs DetectedBugs Detected

 
 
© 2003 - 2009 Orthogonal Software Corporation. All rights reserved. Terms Of Use Privacy Statement