A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Export ERD to SQL Server



 
 
Thread Tools Display Modes
  #11  
Old December 1st, 2008, 08:25 PM posted to microsoft.public.visio.general
mike
external usenet poster
 
Posts: 3,942
Default Export ERD to SQL Server


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"

"JAA149" wrote:


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" wrote:

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" wrote:

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.



"Mike" wrote:

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" wrote:

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" wrote:

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.

  #12  
Old December 1st, 2008, 09:05 PM posted to microsoft.public.visio.general
AlEdlund[_2_]
external usenet poster
 
Posts: 76
Default Export ERD to SQL Server

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

"Mike" wrote in message
...

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"

"JAA149" wrote:


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" wrote:

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" wrote:

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.



"Mike" wrote:

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" wrote:

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" wrote:

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.


  #13  
Old December 1st, 2008, 11:05 PM posted to microsoft.public.visio.general
mike
external usenet poster
 
Posts: 3,942
Default Export ERD to SQL Server

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



"AlEdlund" wrote:

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

  #14  
Old December 3rd, 2008, 10:29 AM posted to microsoft.public.visio.general
JAA149
external usenet poster
 
Posts: 6
Default Export ERD to SQL Server

Mike,

Chech this link out.

http://www.gravitycube.net/blog/post...rchitects.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
  #15  
Old December 3rd, 2008, 03:50 PM posted to microsoft.public.visio.general
mike
external usenet poster
 
Posts: 3,942
Default Export ERD to SQL Server


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" wrote:

Mike,

Chech this link out.

http://www.gravitycube.net/blog/post...rchitects.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

  #16  
Old December 3rd, 2008, 04:02 PM posted to microsoft.public.visio.general
JAA149
external usenet poster
 
Posts: 6
Default Export ERD to SQL Server

what's ur e-mail



"Mike" wrote:


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" wrote:

Mike,

Chech this link out.

http://www.gravitycube.net/blog/post...rchitects.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

  #17  
Old December 4th, 2008, 03:14 PM posted to microsoft.public.visio.general
mgupta
external usenet poster
 
Posts: 3
Default Export ERD to SQL Server

On Dec 3, 10:02*am, JAA149 wrote:
what's ur e-mail



"Mike" wrote:

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" wrote:


Mike,


Chech this link out.


http://www.gravitycube.net/blog/post...-and-Visio-for....


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


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
  #18  
Old December 4th, 2008, 04:45 PM posted to microsoft.public.visio.general
JAA149
external usenet poster
 
Posts: 6
Default Export ERD to SQL Server

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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:29 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.