Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Database Diagrams tool in SQLSERVER Expand / Collapse
Author
Message
Posted Friday, December 14, 2012 2:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 10:05 AM
Points: 69, Visits: 306

Is there any Database Diagrams tool in SQLSERVER ?


Hello :
We are planning to design new Datawarehousing product. I am taking care of Database Design from start.
I am looking for best database diagram tools - logical diagram component - BI

Is there any seperate component/tool in sqlserver 2012 to achieve the process?

Kindly help me on finding the best tools .

Thanks in advance..!
Regards,
Pradeep
Post #1396536
Posted Friday, December 14, 2012 3:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:20 AM
Points: 5,231, Visits: 5,106
SQL has one built in, which you can get to by creating the database diagram in the database diagram under the database object in SSMS.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1396540
Posted Friday, December 14, 2012 4:15 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 10:05 AM
Points: 69, Visits: 306
Is thier any other tools before creation of the tables logical diagram
Post #1396576
Posted Friday, December 14, 2012 4:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:20 AM
Points: 5,231, Visits: 5,106
Visio, Sybase Powerdesigner, sure if you do a search on Google (other search engines available) you will be able to find more.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1396580
Posted Friday, December 14, 2012 1:21 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 14, 2014 3:23 PM
Points: 31, Visits: 43
I recommend Toad Data Modeler.
Post #1396806
Posted Friday, December 14, 2012 2:21 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:47 AM
Points: 7,158, Visits: 15,269
Just about any UML tool can help you create logical models.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #1396817
Posted Tuesday, December 18, 2012 10:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 3:59 PM
Points: 213, Visits: 572
I also use Toad Data Modeler. In addition, I don't know if newer versions of Visio support ERDs that well, if at all.
Post #1397910
Posted Tuesday, December 18, 2012 10:28 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:54 AM
Points: 4,427, Visits: 3,423
imani_technology (12/18/2012)
I also use Toad Data Modeler. In addition, I don't know if newer versions of Visio support ERDs that well, if at all.

Yes, they do, in the Premium Edition.
Post #1397912
Posted Tuesday, December 18, 2012 10:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 3:59 PM
Points: 213, Visits: 572
Good! Does that also apply to Visio 2010?
Post #1397922
Posted Tuesday, December 18, 2012 11:20 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:54 AM
Points: 4,427, Visits: 3,423
Yes, it does.
Post #1397949
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse