Export ERD to SQL Server

[Vu]

All,

I'm using Visio 2007 to create an Entity Relationship Diagram (ERD) model
for a DB. Now, I'm having a hard time to get these tables and relationship
import into SQL Server 2008.

I tried the Export to DB Wizard but only get the diagrams and arrows info.
I need to create tables, columns, and PK/FK from the Visio diagram.

Any suggestions? Thanks in advance.

 

[Mike]

Did you get a reply on how this is done? I am trying to figure out the same
thing. I would appreciate any info you can provide. So far all I have
discovered is that you should be able to do this with the enterprise edition.

Cheers,

Mike

 

[Vu]

Nothing yet. I found the same answer as Enterprise Ed. but I don't know
where to get it.

 

[mgupta]

Nothing yet.  I found the same answer as Enterprise Ed. but I don't know
where to get it.

Which ed. of Visio are you using?
As far as I know, Forward engg is only supported in Visio Enterprise.
W/ professional and standard, you can do reverse engg, but no Forward
engg.
I am also working on creating a Data model using Pro edition.
plz let me know...
Thanks

 

[Mike]

I am using 2007 Pro and have been searching for the EA version for a whole
day now and cannot even find a place to purchase it. I have been told by
several people that you can do this and have even seen it in action, but
cannot find this anywhere.

 

[JAA149]

Hi All,

Did you guys get the answer? I am trying to do the same thing in Access and
All I get is everthing but the tables/views/relationships. Is it called
forward engineering? If enterprise Architect which version? Is it stand alone
or with Visual Studio Net? Please see my Other topic. We could do it in a
very old version.

Regards

 

[Mike]

I have been looking for this and can only find the EA version in the visual
Studio Enterprise Architect but finding the visio that goes along with it is
almost impossible, if you happen to find this please let me know I am having
to recreate an entire infastructure by hand and it is taking forever.

Thanks

 

[JAA149]

Dear Mike,

It was possible in an older version of Visio. Check this link out which says
Visio 2000 Enterprise can do it using the "Generate Database Wizard.

http://www.win.tue.nl/~rp/visio/2mdb/

In another place it is said "Visio 2002 for Access Database Developers" can
do it.

http://www.skandus.com/visio.htm

On an other note I have seen done this this in a book called "Absolute
Beginner’s Guide to Databases By John V. Petersen" in which the it is done by
using Visio. However the book fails to mention the Visio version. On
extensive search the version may be by seeing the pic in the book Visio Pro
Technical.

Visio has

1 - Visio 2000 (6.0; Standard, Professional, Technical, Enterprise)
2 - Visio for Enterprise Architects 2003 (VEA 2003) (based on Visio 2002) IN
Visual Studio .NET 2003 Enterprise Architect
3 - Office Visio for Enterprise Architects 2005 (VEA 2005) (based on Visio
2003) IN
Visual Studio 2005 Team Suite &
Visual Studio 2005 Team Architect

It is imposible to find any of these. I have been searching for 1 week now.
Still i am trying. If i find the version I will e-mail you.

(e-mail address removed)

 

[Mike]

Thanks, I really appreciate this, I have been looking for a few weeks now, I
am in the meantime having to build the complete database infastructure by
hand, very time consuming. Thanks again if I get anywhere I will let you know.

 

[JAA149]

Mike,

I got the "Visio 2003 for Visual Studio 2005 EA". But I can not install it
because I do not have Visual Studio. What are these Microsoft Guys. Do you
have the Visual Studio.

 

[Mike]

I have Visual Studio 2005 .NET EA

but I cannot seem to see how to get it to forward engineer....

any Ideas?

"mike at mickey-martin dot com"

 

[AlEdlund]

the visio install for ea is not automatic, but is in a separate directory on
the install media.
al

 

[Mike]

Where? I have not been able to find it and I have 2003 not 2005 that was a
typo.

 

[JAA149]

Mike,

Chech this link out.

http://www.gravitycube.net/blog/post/Visual-Studio-2008-and-Visio-for-Enterprise-Architects.aspx

As you have Visual Studio 2005.Net EA you should be able ti install the

"Visio 2003 for Visual Studio 2005 EA". Now here the problem. The visio with
Visual Studio 2005.Net EA is actually Visio 2003.

I got the Visio 2003 for Enterprise Architect. If u get the same u can
forward engineer.

Regards

JAA

 

[Mike]

Any ideas on where I can find a copy of the Visio 2003 EA? I have been
looking for this for a while, I can only find the professional 2007 edition.

 

[JAA149]

what's ur e-mail

(e-mail address removed)

Any ideas on where I can find a copy of the Visio 2003 EA? I have been
looking for this for a while, I can only find the professional 2007 edition.

 

[mgupta]

what's ur e-mail

(e-mail address removed)

I have been working on same issue. data modeling using visio. MS sucks
Was busy with other issues so, was away from modeling project..but
now,back at VISIO
I couldn't find Visio Enterprise edition either.
Do you know where it can find?
thanks

 

[JAA149]

Mike & Gupta,

I just had a break through. I was able to generate

1 - Access Database
2 - SQl Database
3 - DDL Script

I finaly found the Viso 2000 Enterprise Architect
Lets try this first. Go to your Viso which ever version. Let's say Visio
2007 Pro. Go to tools & select Developer Mode. Also uou can not do this if
you select any other diagram. You have to select Databse Model Template.

I also found the Viso 2003 for Visual Studio Net. But I can not install it
because one needs the Visual Studio Net to do so.

Any way the Visio 2000 EA worked like a charm. Give me you e-mails address
so I can send you instructions.