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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-10-07 : 22:47:12
|
| Hi,Do you know how to create data model for a SQL server database by reverse engeneering?Is there any tool available with SQL Server 2005 suite. If not available, any other tool you guys recommend, preferably any freeware.Thanks in advance. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-10-07 : 23:15:57
|
| It's not free, but Microsoft Visio Professional Edition has a database reverse-engineering feature. SQL Server Management Studio can also generate database diagrams, but you can't do much with them except print them out.ErWin would be my next suggestion, but it's not free. Google should have a few more. |
 |
|
|
Raibeart
Starting Member
8 Posts |
Posted - 2009-10-08 : 15:14:54
|
| SQL Server comes with the database diagram tool built into it. That will give you an ERD of the database. Why do you need to reverse engineer it to get one? You can even break it into sections of the database for printing and viewing purposes. Like, all of the customer related tables, all of the order related tables, etc. |
|
|
|
|
|
|
Data Model tool