Generating DDL from ERD

[Shane]

Hi,

I have MS Visio 2002 Professional edition. I would like to know how to
generate DDL for tables that i create in Visio (Database Modeling
Diagram).

I have used Visio to reverse engineer ERDs from a database, but want
to be able to design in Visio and let it generate the DDL
automatically. I am confident that Visio accomplishes this --- just
unsure if Visio 2002 Pro. does.

help will be much appreciated...thanks!
Shane

 

[Anthony Bloesch [MSFT]]

Visio Enterprise Architect (which ships with Visual Studio Enterprise
Architect) will do this.

Anthony
--------------------
From: (e-mail address removed) (Shane)
Newsgroups: microsoft.public.visio.database.modeling
Subject: Generating DDL from ERD
Date: 16 Jan 2004 10:09:11 -0800
Organization: http://groups.google.com
Lines: 13
Message-ID: <[email protected]>
NNTP-Posting-Host: 209.226.10.130
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1074276552 30327 127.0.0.1 (16 Jan 2004
18:09:12 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: Fri, 16 Jan 2004 18:09:12 +0000 (UTC)
Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.su
l.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!po
stnews1.google.com!not-for-mail
Xref: cpmsftngxa07.phx.gbl microsoft.public.visio.database.modeling:3488
X-Tomcat-NG: microsoft.public.visio.database.modeling

Hi,

I have MS Visio 2002 Professional edition. I would like to know how to
generate DDL for tables that i create in Visio (Database Modeling
Diagram).

I have used Visio to reverse engineer ERDs from a database, but want
to be able to design in Visio and let it generate the DDL
automatically. I am confident that Visio accomplishes this --- just
unsure if Visio 2002 Pro. does.

help will be much appreciated...thanks!
Shane



--

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.