Database layout to SQL?

V

VilMarci

Dear Community,

I've created a database layout with Visio for a presentation document. I
wonder if it's possible to create the same layout in a MS SQL or Access
database?
If possible, then how, and is it possible to make changes in the layout in
Visio and apply those in SQL?

Thanks,
Marton
 
C

chrisb

Hello Marton,

If you have the Enterprise Architect version of Visio, then the answer
is Yes.

My article: http://www.codeproject.com/gen/design/visioDatabase.asp
explains how (and is equally applicable to either Sql Server or
Access).

Visio 2003 for Enterprise Architect comes with MSDN Premier and Team
System versions. Other versions of Visio I think allow you to import
a database schema, but not export changes back out.

Regards
Chris.
 
C

chrisb

Of course, that should be MSDN Premium, MSDN Premier is a figment of
my imagination!
Chris.
 
V

VilMarci

Chris,

I have Visio Professional 2003 SP2 (11.5509.8122) Is this feature missing in
this version?

Marton
 
A

Al Edlund

The enterprise architect edition comes with Visual Studio and is not a
separately orderable product.

al
 
C

chrisb

Hi Marton,

You need the Enterprise Architect version (Help | About reports it as
"Microsoft Office Visio for Enterprise Architects 11.4301.8132).

As Al says, it's only available with Visual Studio.

I believe that the Pro version can import a database schema, but not
sync and export.

Chris.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top