Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Steve2106
Posting Yak Master
183 Posts |
Posted - 2012-10-01 : 11:05:30
|
Hi There,Sorry if this is the wrong place to post this.Does anyone use a Data Mapper or schema inspector?I would like some advice on software that gives a visual layout of data tables and their relationships.Some links to sites would be appreciated.Best Regards,Steve |
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2012-10-01 : 14:31:14
|
This is probably the wrong forum for such a question, but I'll try to help. Are you looking for an Entity Relationship Diagram? You can produce a rudimentary Physical data model within SQL Server using the Database Diagrams feature. Alternately, Microsoft Visio allows you to reverse engineer a database and has a lot more layout / organizational options. Moving into more enterprise solutions would be CA ErWin or EmbarcaderoER/Studio, which offer a lot more features geared toward a larger organization with multiple database developers / architects such as documentation templates (conceptual, logical, physical, data dictionary) and forward engineering data models. |
|
|
|
|
|