April 6, 2009 at 11:14 am
In SQL 2000, u can use the wizard to generate Diagrams of ur database. Its really easy to use, Just Rt.Click on Database diagram folder under database
http://codebetter.com/blogs//images/codebetter_com/peter.van.ooijen/53/o_o_DiagramWizard1.jpg
April 21, 2009 at 12:22 am
I use Visio for Enterprise Architects for this. It has a fairly good reverse engineering function allowing you to connect to the database and extract all the SQL object metadata. You can then assemble the ERD in Visio by creating a consolidated view or mutiple pages each concentraing on a set of tables.
Stephen Marais
Integration Architect
Digiata Technologies
www.digiata.com
April 23, 2009 at 6:43 am
Even bog standard Visio Professional will reverse engineer. It is the enterprise architect edition that forward engineers.
You could look at Sparx Data Architect as a possible tool or Erwin.
April 24, 2009 at 8:30 am
Hi, well there is another tool called ER/Studio from Embarcadero Technologies, and is the most complete and easy to use, among the previus mentioned tools.
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
