MS SQL EXPRESS database diagram

**cash_site** · August 28th, 2009, 01:37 AM

Hi Team,

I was wondering if anyone knew any good (free) apps to reverse engineer a SQL express 2005 database into an E-R Diagram / UML showing relationships, 1-to-Many, properties etc.

I know there is a Database Diagram section in the SQL Studio Manager, but it is tedious to manually load the tables, create the links etc... Is there an automated method?

I've got an old version of StarUML, is there a plug-in to extract the SQL Schema and create the diagrams?

I've got the ODBC links already created and can access the tables from ACCESS, Visual Studio et al.

Cheers and TIA!

**rik** · August 28th, 2009, 19:11 PM

Are you just looking for a diagramming program?

"Dia is a gtk+ based diagram creation program released under the GPL license.

Dia is inspired by the commercial Windows program 'Visio', though more geared towards informal diagrams for casual use. It can be used to draw many different kinds of diagrams. It currently has special objects to help draw entity relationship diagrams, UML diagrams, flowcharts, network diagrams, and many other diagrams. It is also possible to add support for new shapes by writing simple XML files, using a subset of SVG to draw the shape."

Linkaging Thingy

**cash_site** · August 30th, 2009, 14:30 PM

Yeah, looking for a diagramming application but one that can reverse engineer my SQL tables and automatically generate the diagrams, their relationships and identify properties such as Primary Keys, and 1-Many connections.

**cash_site** · September 10th, 2009, 08:01 AM

*bump

August 28th, 2009, 01:37 AM	#1
cash_site Security Intelligence TZ Veteran Join Date: Jul 2002 Location: Software Paradise Posts: 4,210	MS SQL EXPRESS database diagram Hi Team, I was wondering if anyone knew any good (free) apps to reverse engineer a SQL express 2005 database into an E-R Diagram / UML showing relationships, 1-to-Many, properties etc. I know there is a Database Diagram section in the SQL Studio Manager, but it is tedious to manually load the tables, create the links etc... Is there an automated method? I've got an old version of StarUML, is there a plug-in to extract the SQL Schema and create the diagrams? I've got the ODBC links already created and can access the tables from ACCESS, Visual Studio et al. Cheers and TIA! __________________ --- 0wN3D by 3gG ---

August 28th, 2009, 19:11 PM	#2
rik Old, Cranky and Perverted Super Moderator Join Date: Aug 2003 Location: Watching Your every move... Posts: 5,299	Are you just looking for a diagramming program? "Dia is a gtk+ based diagram creation program released under the GPL license. Dia is inspired by the commercial Windows program 'Visio', though more geared towards informal diagrams for casual use. It can be used to draw many different kinds of diagrams. It currently has special objects to help draw entity relationship diagrams, UML diagrams, flowcharts, network diagrams, and many other diagrams. It is also possible to add support for new shapes by writing simple XML files, using a subset of SVG to draw the shape." Linkaging Thingy __________________ Spyware Removal Tips \| Read the Forum Rules

August 30th, 2009, 14:30 PM	#3
cash_site Security Intelligence TZ Veteran Join Date: Jul 2002 Location: Software Paradise Posts: 4,210	Yeah, looking for a diagramming application but one that can reverse engineer my SQL tables and automatically generate the diagrams, their relationships and identify properties such as Primary Keys, and 1-Many connections. __________________ --- 0wN3D by 3gG ---

September 10th, 2009, 08:01 AM	#4
cash_site Security Intelligence TZ Veteran Join Date: Jul 2002 Location: Software Paradise Posts: 4,210	*bump __________________ --- 0wN3D by 3gG ---

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode