InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 19:26:32 GMT20http://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxI'm making a decision now at my current workplace.Folks at ERStudio wont return my calls, etc.Probably gonna go with ERWin just by default.Wed, 28 Oct 2009 15:32:38 GMTGregoryAJacksonhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxAfter using ERwin for many years, I shifted to ERStudio at beginning of this year. And I am happy with the shifting. (SQL only, it is cheap)Wed, 28 Oct 2009 15:29:56 GMTDavid Luhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxMy money is with ERWin; be sure you get the yourBrain plugin working with it :-DTue, 27 Oct 2009 12:55:33 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxThe place I work is using EA and having used ERWin and ERStudio extensively in the past, I absolutely HATE EA.This could very well be a "You dont know how to use the tool" thing, but so far, I cant do the following things:1) Name my constraints indexes2) define referential integrity and migrate PKs to Linked tables with an FK3) define Schemas4) Resolve Many To Many relationships5) Create Database Scripts that utilize specifi db attributes (File Groups, etc)6) Define relationship and cardinality rules7) etc etc etcI'm hoping I find that it's just a learning curve thing. So far....I'm not impressed at all.so far this tool seems very much like a UML Modeling tool (which it is).Thu, 15 Oct 2009 17:43:02 GMTGregoryAJacksonhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxHiERWin is best.Thanks -- Vijaya Kadiyalahttp://dotnetvj.blogspot.comMon, 09 Feb 2009 09:11:39 GMTVijaya Kadiyalahttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxI used Erwin never had issues with however currently I am addicted to SPARX(Enterprise Architect). It is a cool to use.Wed, 04 Feb 2009 06:44:36 GMTchegoane.mabelanehttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxIf I'm doing something small, paper or Visio work well. If I need to manage and handle changes to a larger database, I prefer ERStudio over Erwin. Haven't used TOAD.Tue, 03 Feb 2009 13:29:39 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspx[font="Verdana"]Heh. Nice to see someone who likes TOAD (I assume for SQL Server?) Personally I hate the product, but I know other people disagree. My issue with TOAD is that it tries to be a "jack of all trades" (and hence...) I have to admit I didn't even realise TOAD had a database design part, although it's been several years now since I had to use it, so it may have been a more recent addition.I know a bunch of Oracle DBAs who are moving to SQL Server, and keep insisting that they need the SQL Server version of TOAD. I've been telling them to learn Management Studio instead. Perhaps I need to revisit that?[/font]Tue, 03 Feb 2009 13:20:05 GMTBruce W Cassidyhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxTOAD 3.0 tool is the best data designing tool .and another one is ER win data modeler.But my choice is TOAD 3.0.Mon, 02 Feb 2009 21:20:00 GMTjanardhan.kondurihttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxI too have used ERStudio for years now. Good tool. It can get expensive, especially if you get cross-platform licenses. If you are sql server only they do (or used to) offer a much cheaper sql server only license.Never having used a modelling tool, you may want to stick with visio though. ERStudio has a LOT of 'flexibility'. :)Mon, 02 Feb 2009 12:40:14 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxI have used both ERWin and Embarcadero ERStudio. I currently use ERStudio and I feel it offers a lot as compared to ERWin. One feature that i liked is it has a database capacity planning. I guess you can download a free trial of ERStudio and try for yourself a few days before you decide to buy.AmolMon, 02 Feb 2009 12:30:51 GMTAmolNaikhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxI use NotepadWithPencil Version A4 and Brain Version 1.0 (I believe) to start. Sometimes MS Visio is quite handy, specially if you have an existing database and you want to get an overview about existing tables and relations (not always works). If it really needs to be professional I prefer PowerDesigner. Check this link: [url]http://www.sybase.com/products/modelingdevelopment/powerdesigner[/url]Mon, 02 Feb 2009 01:12:14 GMTliebesiechhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspx[font="Verdana"]Embarcadero's ERStudio was a favourite of mine in the past.I never really liked ERWin (even before CA bought it, and it's only gotten worse since then.) But some people swear by it.I've been using Sybase PowerDesigner recently, and that seems to be okay.For basic data modelling I use a white board and something like Visio. I already have Visio anyway, and I don't particularly need to do a lot of in-depth modelling. So you may want to consider just how much you need from your tool. If all you need to do is throw together some diagrams, then Visio may be enough.[/font]Sun, 01 Feb 2009 13:50:57 GMTBruce W Cassidyhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxMy absolute favorite is Embarcadero ERSTudio. Fantastic set of functionality.CA offers another that's extremely popular ERWin. There are a couple of others available, but those are the two big ones.Thu, 29 Jan 2009 07:32:30 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic645637-361-1.aspxDear All, Can anyone suggest me a good tool for DATA MODELLING pls...?I have never used one. Thanks in advance.Santhu.Thu, 29 Jan 2009 00:46:07 GMTJoy Smith San