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.