Create database diagram - Visio

User avatar
agibsonsw
SilverLounger
Posts: 2403
Joined: 05 Feb 2010, 22:21
Location: London ENGLAND

Create database diagram - Visio

Post by agibsonsw »

Hello.

I want to use Visio 2003 to create a relationship diagram/schema using the 'Entity Relationship (Metric)' tools, but just need a little guidance.

I know that an Entity is a table and a View is a saved query. But what is a 'Category'? What is a 'Dynamic connector'? Thanks, Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.

User avatar
Wendell
4StarLounger
Posts: 482
Joined: 24 Jan 2010, 15:02
Location: Colorado, USA

Re: Create database diagram - Visio

Post by Wendell »

Here are a couple of resources you might want to look at -Connectors and Glue and Define categories in a Database Model diagram. And if you want to model an existing database, the quickest way is to create the E/R constraints in your Access or SQL Server database. Then you can import those into visio and it does most of the work for you.
Wendell
You can't see the view if you don't climb the mountain!

User avatar
agibsonsw
SilverLounger
Posts: 2403
Joined: 05 Feb 2010, 22:21
Location: London ENGLAND

Re: Create database diagram - Visio

Post by agibsonsw »

Hi. I understand that a category is a simple lookup table. A dynamic connector could represent a simple join?

How can I import my relationships diagram from my Access database to Visio? Andy. (Forget this - just found it under Reverse Engineer..)
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.

dasadler
5StarLounger
Posts: 889
Joined: 25 Jan 2010, 16:26
Location: Garden Grove, CA 92844 USA

Re: Create database diagram - Visio

Post by dasadler »

agibsonsw,

So where is Reverse Engineer? I was eagerly looking forward to the answer to your question.
Don

User avatar
agibsonsw
SilverLounger
Posts: 2403
Joined: 05 Feb 2010, 22:21
Location: London ENGLAND

Re: Create database diagram - Visio

Post by agibsonsw »

Hello.
I you begin a blank database model diagram in Visio 2003, a new menu option of Database appears, with Reverse Engineer as the first option.
Clever stuff! Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.

dasadler
5StarLounger
Posts: 889
Joined: 25 Jan 2010, 16:26
Location: Garden Grove, CA 92844 USA

Re: Create database diagram - Visio

Post by dasadler »

Okay, thanks.
Don

User avatar
Charlotte
Her Majesty
Posts: 499
Joined: 19 Jan 2010, 07:13

Re: Create database diagram - Visio

Post by Charlotte »

agibsonsw wrote:Hello.
I you begin a blank database model diagram in Visio 2003, a new menu option of Database appears, with Reverse Engineer as the first option.
Clever stuff! Andy.
What edition was that, Andy? I had Visio 2003 Professional edition and it lacked that feature.
Charlotte

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Create database diagram - Visio

Post by HansV »

Best wishes,
Hans