Produce Schema from existing database

[LinsLo]

Can someone help me out with this? I have a SQL database and would like to print out the relationships between all of the tables. The database has a large amount of tables. Any advice would be greatly appreciated!


LinsLo

 

[mrdenny]

You've got a few options which are all faily easy. One is to use the database diagram option with SQL Enterprise Manager. Granted the printouts suck, but it will work for you. The method that I prefer is to use Visio. It was the option to reverse engineer the database and create all the relationships, and it does a much nicer job of printing them all out.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[LinsLo]

Can you point me in the direction to find this option in Visio?

Thanks!!!


LinsLo

 

[Corran007]

im not sure if its the same as in what version of visio im using, but in mine you select the database model diagram for the type of drawing then under the header DATABASE at the top, select reverse engineer. then just follow the instructions. and i concur on visio being the easiest for ther price.

 

[mrdenny]

That's how I've always done it.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[RiyaKumar]

I think the 'Reverse Engineer' option is available only in the Visio professional version.