Database layout to SQL?

[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

 

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

 

[chrisb]

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

 

[VilMarci]

Chris,

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

Marton

 

[Al Edlund]

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

al

 

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