InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 04:27:43 GMT20http://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxBe 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.Wed, 02 Jan 2013 09:01:04 GMTEdVassiehttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspx[quote][b]Jeff Moden (12/18/2012)[/b][hr][quote][b]mpradeep23 (12/14/2012)[/b][hr]Is thier any other tools before creation of the tables logical diagram[/quote]Heh... cocktail napkins and beer coasters![/quote]HAH!! Yep - that is about all I use for "logical" modeling too! :cool: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). :-PWed, 19 Dec 2012 04:21:55 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspx[quote][b]mpradeep23 (12/14/2012)[/b][hr]Is thier any other tools before creation of the tables logical diagram[/quote]Heh... cocktail napkins and beer coasters!Tue, 18 Dec 2012 21:41:38 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxWow, I wish I had known that earlier.Tue, 18 Dec 2012 11:56:56 GMTimani_technologyhttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxYes, it does.Tue, 18 Dec 2012 11:20:01 GMTRevenanthttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxGood! Does that also apply to Visio 2010?Tue, 18 Dec 2012 10:34:54 GMTimani_technologyhttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspx[quote][b]imani_technology (12/18/2012)[/b][hr]I also use Toad Data Modeler. In addition, I don't know if newer versions of Visio support ERDs that well, if at all.[/quote]Yes, they do, in the Premium Edition.Tue, 18 Dec 2012 10:28:05 GMTRevenanthttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxI also use Toad Data Modeler. In addition, I don't know if newer versions of Visio support ERDs that well, if at all.Tue, 18 Dec 2012 10:20:36 GMTimani_technologyhttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxJust about any UML tool can help you create logical models.Fri, 14 Dec 2012 14:21:30 GMTMatt Miller (#4)http://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxI recommend Toad Data Modeler.Fri, 14 Dec 2012 13:21:03 GMTmadhankumar.rajendranhttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxVisio, Sybase Powerdesigner, sure if you do a search on Google (other search engines available) you will be able to find more.Fri, 14 Dec 2012 04:24:30 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxIs thier any other tools before creation of the tables logical diagramFri, 14 Dec 2012 04:15:49 GMTmpradeep23http://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxSQL has one built in, which you can get to by creating the database diagram in the database diagram under the database object in SSMS.Fri, 14 Dec 2012 03:10:23 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1396536-147-1.aspxIs 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 - BIIs there any seperate component/tool in sqlserver 2012 to achieve the process?Kindly help me on finding the best tools .Thanks in advance..!Regards,PradeepFri, 14 Dec 2012 02:54:51 GMTmpradeep23