Reverse Engineer database for C# project

[microsoft.public.dotnet.languages.csharp]

I have Visio Professional that comes with the MSDN Universal
subscription. I need to reverse engineer a database using Visio and
create the DDL. I can only find information on creating the script by
building the database within Visio. Our database is already created. I
want to reverse engineer it. The main problem is that we don't know
what you have to do to map the objects that Visio creates and assign
them as the different database objects (fields, etc). Anyone know where
I can find some good documentation on reverse enginieering with Visio?

Thx,
Marty




*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Nick Malik]

Start Visio
Open a new drawing
In the dialog that allows you to select what type of drawing, select the
Database category, then "Database Model Diagram"
You will get a new top level menu, called "Database".
From the Database menu, select Reverse Engineer.

The rest is self-explanitory.

Good Luck,
--- Nick

 

[microsoft.public.dotnet.languages.csharp]

I don't think it is self-explanatory.

What do you do to create the DDL? I can reverese engineer the database
and get it to create all of the table objects but those objects have to
be mapped back to database tables and fields. How do you do that so
that the DDL will get created? Selecting reverse engineer from the menu
and then selecting to create the DDL will not create the DDL until the
objects are mapped correctly.

Any ideas/help?

Thx



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!