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
  #1  
Old October 6th, 2008, 07:01 PM posted to microsoft.public.visio.general
VU
external usenet poster
 
Posts: 3
Default Export ERD to SQL Server

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.
--
Vu
  #2  
Old October 7th, 2008, 04:53 PM posted to microsoft.public.visio.general
mike
external usenet poster
 
Posts: 3,942
Default Export ERD to SQL Server

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

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.
--
Vu

  #3  
Old October 8th, 2008, 05:49 AM posted to microsoft.public.visio.general
VU
external usenet poster
 
Posts: 3
Default Export ERD to SQL Server

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


"Mike" wrote:

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

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.
--
Vu

  #4  
Old October 8th, 2008, 01:49 PM posted to microsoft.public.visio.general
mgupta
external usenet poster
 
Posts: 3
Default Export ERD to SQL Server

On Oct 8, 12:49*am, Vu wrote:
Nothing yet. *I found the same answer as Enterprise Ed. but I don't know
where to get it.
--
Vu

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


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.
--
Vu


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
  #5  
Old October 8th, 2008, 03:10 PM posted to microsoft.public.visio.general
mike
external usenet poster
 
Posts: 3,942
Default Export ERD to SQL Server

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.
  #6  
Old November 28th, 2008, 05:30 PM posted to microsoft.public.visio.general
JAA149
external usenet poster
 
Posts: 6
Default Export ERD to SQL Server

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.

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

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.

  #8  
Old December 1st, 2008, 02:45 PM posted to microsoft.public.visio.general
JAA149
external usenet poster
 
Posts: 6
Default Export ERD to SQL Server

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.

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

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.

  #10  
Old December 1st, 2008, 05:59 PM posted to microsoft.public.visio.general
JAA149
external usenet poster
 
Posts: 6
Default Export ERD to SQL Server


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.

 




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 11:07 AM.


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