| Author |
Topic |
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
 Posted - 2007-02-27 : 01:51:56
|
| Hi All, Can anyone tell me what would be a write tool for making E-R Diagrams for SQL SERVER 2005?? I Evaluated the following tools but didnt found them user friendly for usage. Case Studio from RkSoftXCase Tool. Any Suggestions are welcome. Regards,Chiraghttp://chirikworld.blogspot.com/ |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-27 : 02:38:29
|
Visio?also SSMS will do it - it's the same interface as was in EM.
www.elsasoft.org |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-02-27 : 02:45:01
|
| Visio, But i dont think it will create the script based on the models, for high level disign i used visio.. Where there is a option of Creating ER diagrams in SSMS??? i didnt found :(.. and EM Diagrams are normally based on the tables which are already existing in the database .. you can not add the new table just for reviewing..Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-27 : 02:50:14
|
I think the professional version of visio will create a script.and you are right, SSMS will only show diagrams for existing tables.
www.elsasoft.org |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-27 : 03:22:59
|
"SSMS will only show diagrams for existing tables"But won't that encourage people to just add tables & columns willy-nilly?  |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-27 : 12:28:21
|
sure, but just use a toy server (such as your own dev box) while doing so. if you are designing a db, who cares if real tables are being created behind the scenes or not? as long as you are not doing it on a prod server!EDIT: and make sure that once you have something you like, extract it to scripts and check it into source control!
www.elsasoft.org |
|
|
|
peterlemonjello
Yak Posting Veteran
53 Posts |
Posted - 2007-02-28 : 09:14:59
|
| If you have the money, PowerDesigner |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-28 : 14:31:13
|
| We used to use PowerDesigner. Or whatever is was called back then ... Star Designor maybe?Anyways ... I liked it a lot back then ...Kristen |
|
|
|
vladimir.stokic
Starting Member
25 Posts |
Posted - 2007-03-05 : 03:15:53
|
| We use ERwin and want to migrate to Power Designer 12 in the near future. The cost is significant, but you can do almost anything in PD. Both tools have great capabilities regarding the script generation, so you can easily preview and generate SQL DDL or DML scripts. |
|
|
|
tadin
Yak Posting Veteran
63 Posts |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-03-19 : 16:45:53
|
| Sorry guys for late replies... I had tried out Case Studio, but did not found it much user friendly though.. I finally went with the Jezemine suggestions... of using SSMS.. and it quite cool.. only thing i hate about the SQL SERVER 2005, is the scripting methodology.. Rest everything is fine.. Can any one tell me what tools are available for generating scripts in 2005, since SSMS just sucks.. or may be Enterprise manager was very much user user friendly.. Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
|
E- R Diagram Tool