View Single Post
 
Old January 28th, 2008, 11:32 PM
robprell robprell is offline
Friend of Wrox
 
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The designer in SQL 2000 is useless, visio is only good for documenting your database design, not modifying it, or making clear print outs of the relationships. The two most popular tools in the industry are ER-Win by CA, and Er-Studio by Embarcadero. Er-Win has been around the longest but I like Er-Studio better. They both have issues and neither does everything correctly but they are so much better than the tools you listed it's like night and day.