Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Modeling Expand / Collapse
Author
Message
Posted Monday, May 17, 2010 7:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 2:21 AM
Points: 35, Visits: 166
I have built a database and wanted to verify that it has no obvious errors in the design.
previously i have used visio 2003 to reverse engineer it and get it to find any errors.

However, visio 2003 has issues reading sql 2005 database. While to upgrade to visio 2007 requires different versions visual studio and once you have visual studio 2008 then no version of visio is compatible 100%

Is there any tool out there that I could use to verify my database model. Is there something in Visual studio 2008 or some add on or free product that will pick up errors in my model ..eg no primary key, incompatible datatypes etc etc.

regards

Erick



Post #923242
Posted Tuesday, May 18, 2010 6:10 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 6:30 PM
Points: 15,518, Visits: 27,900
Best tool I know of for working with models is Embarcadero ERStudio.

But if you do a search, there are free ones out there, but you're going to get what you pay for.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #923489
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse