Database Diagrams tool in SQLSERVER

Question

Database Diagrams tool in SQLSERVER

mpradeep23

SSCommitted

Points: 1868
More actions
December 14, 2012 at 2:54 am

#393799

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

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

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.

mpradeep23 SSCommitted Points: 1868 More actions · Answer 2

Is thier any other tools before creation of the tables logical diagram

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

Visio, Sybase Powerdesigner, sure if you do a search on Google (other search engines available) you will be able to find more.

madhankumar.rajendran SSC Rookie Points: 39 More actions · Answer 4

madhankumar.rajendran

SSC Rookie

Points: 39

December 14, 2012 at 1:21 pm

#1568827

I recommend Toad Data Modeler.

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 5

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?

imani_technology SSCrazy Eights Points: 8200 More actions · Answer 6

I also use Toad Data Modeler. In addition, I don't know if newer versions of Visio support ERDs that well, if at all.

Revenant SSC-Forever Points: 42467 More actions · Answer 7

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.

imani_technology SSCrazy Eights Points: 8200 More actions · Answer 8

imani_technology

SSCrazy Eights

Points: 8200

December 18, 2012 at 10:34 am

#1569677

Good! Does that also apply to Visio 2010?

Revenant SSC-Forever Points: 42467 More actions · Answer 9

Revenant

SSC-Forever

Points: 42467

December 18, 2012 at 11:20 am

#1569703

Yes, it does.

imani_technology SSCrazy Eights Points: 8200 More actions · Answer 10

imani_technology

SSCrazy Eights

Points: 8200

December 18, 2012 at 11:56 am

#1569727

Wow, I wish I had known that earlier.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 11

mpradeep23 (12/14/2012)
Is thier any other tools before creation of the tables logical diagram

Heh... cocktail napkins and beer coasters!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 12

Jeff Moden (12/18/2012)
mpradeep23 (12/14/2012)
Is thier any other tools before creation of the tables logical diagram
Heh... cocktail napkins and beer coasters!

HAH!! Yep - that is about all I use for "logical" modeling too! 😎

I have used Embarcadero's ERStudio for probably a dozen years now. Incredible capabilities, and if you purchase a SQL Server only license it is very reasonably priced for the functionality it brings to the table (pun intended). 😛

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

EdVassie SSC Guru Points: 60472 More actions · Answer 13

Be aware that the SQL Server database diagram is a live representation of the database. If you drop a table from the diagram it is dropped from the database, so use this tool with care. It can be safer to stick with the cocktail napkins and beer coasters, plus using a phone camera to capture significant versions.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara