Need a simple, good (fairly priced) ER Tool

I've been using ERWin for about 10 years now. My version is ancient and I do not think it's worth paying the ridiculous upgrade price!

Problem is it's starting to show its age - I've been using it primarliy for MS SQL.

I wish I could justify Embarcadero's ER/Studio, but I just need something that will allow me to design a DB and sync it.

I've checked out http://stackoverflow.com/questions/674911/light-weight-er-diagram-tool, but nothing fits except Schemabank. But a web based tool has too many drawbacks (recurring fees, less integrated, off-site storage of data).

I've also used SQL Maestro for regular queries and DB management. It was OK, but has a few definite shortcomings. Has anybody used the ER designer successfully?

What do you guys use?

-------------Problems Reply------------

We just use Visual Studio Database Edition (which is now included in the Team System Developer Edition).

The possibility to create diagrams in SQL Server as well as linking ER diagrams in Visio.

We currently use ORM tools so the documentation diagrams are the ORM diagrams in some cases.

In short, 10 years ago we used and could defend the extra cost of a purpose built ER tool. Now we just use what is build into the other tools that we use.

Try Netbeans, its free and open source. http://www.netbeans.org/

Instructions on ER diagrams and SQL databases http://wiki.netbeans.org/ERDRequirementsV2

And instructions on connecting to MSSQL http://wiki.netbeans.org/AccessMssql

I quite like the Quest Toad Data Modeler - so far it seems quite capable, but it's a fraction of the cost of what other "professional grade" ER tools normally cost.

Check it out! I'd say it's worth a good look for sure.

You could also try DB designer -- freebie for MySQL.

Category:database design Views:0 Time:2009-10-24

Related post

  • How can create simple PHP Search Engine Submission tool? 2010-04-02

    How can create simple PHP Search Engine Submission tool, which allows that to submit the site URL to multiple search engines such as "http://www.google.com/addurl?q=www.yoursite.com&hl=&dqq=" and also "http://www.bing.com/webmaster/SubmitSite

  • Simple Database Viewer and Search Tool 2009-10-08

    I've exported all the old orders out of our old store into a mySQL DB. Anyone know of a simple project or web based app that will let you search all fields with a wildcard? So if I type in sha automatically any results with those letters would popup.

  • A consistent and simple group of IDE and tools for embedded code and unit test in C++? 2010-05-22

    I’m starting a new firmware project in C++ for Texas Instrument C283xx and C6xxx targets. The unit tests will not run on the target, but will be compiled with gcc/gcov on a PC with windows (and run as well on PC) with simple metrics for tested code c

  • Simple layout mock-up design tool? 2012-03-24

    I want to layout some website mockups without doing code. Just start with the design to put my idea in something that I can see. Something simple like just doing it on plain pen and paper but on the computer, be it a web tool or an actual program app

  • Magento simple product tier pricing by percentage? 2012-01-12

    This is more of a general question... Does anybody know of a hack or an existing module which will allow users to define tier prices on Simple products as a percentage rather than an actual value? So this would be the scenario: Price: £10 Price for 2

  • Simple *nix tool for listening to HTTP requests and logging the request data 2011-12-14

    What's a simple, easy-to-use *nix tool that will listen to requests on a given port and log the request header and body? --------------Solutions------------- How about netcat? sudo nc -l 80 Update: Here's what I see when I send a request through a br

  • What are good grep tools for Windows? 2008-09-17

    Any recommendations on grep tools for Windows? Ideally ones that could leverage 64-bit OS. I'm aware of Cygwin, of course, and have also found PowerGREP, but I'm wondering if there are any hidden gems out there? --------------Solutions------------- B

  • "Dump log to visually appealing document" tool for Subversion? 2010-08-11

    I'm considering switching from Subversion to Mercurial with a few repositories whose revision history I don't need at everyday work, but which would be nice to store in some kind of document - as proof of activity for the clients, as a quick way to l

  • What library or graphics engine would be suitable for a full-screen professional retail tool? 2011-02-18

    I find myself in the unique position of having to find a suitable 2D graphics engine (or 3D with easy-to-use support for 2D interfaces) for the creation of a simple, full-screen retail sales tool for my business. I have been considering the use of th

  • Very delayed IIS response from WCF service when returning fairly large data set 2011-08-10

    I have an IIS 7 hosted WCF service that is mainly being used to return data through the entity framework. One of the operation contracts/service methods returns a list of roughly 17000 very simple and fairly small entity objects. The response size en

  • Java benchmarking tool 2008-11-03

    I have written a small java application for which I need to obtain performance metrics such as memory usage, running time etc., Is there any simple to use performance measurement tool available? --------------Solutions------------- Yourkit is pretty

  • How can I calculate a fair overall game score based on a variable number of matches? 2008-11-11

    I have a game in which you can score from -40 to +40 on each match. Users are allowed to play any number of matches. I want to calculate a total score that implicitly takes into account the number of matches played. Calculating only the average is no

  • What tool can monitor my SQL Server usage and suggest optimizations? 2009-03-20

    I have a vague recollection of hearing about a profiling tool that could sit and watch the SQL Server that is serving data to my production website. In particular, I'm looking for a tool that can, based on profiling what is actually taking the most t

  • Useful tools for working with Subversion 2009-05-11

    There are a number of great tools out there which integrate with Subversion and do some really neat things. I’ve tried a number of them but ultimately only tend to use the following on a regular basis: Tortoise (the ubiquitous Explorer plugin) Visual

  • Are there any good/automateable dependency management tools for managing application, database & external resources dependencies? 2010-02-02

    I would like to build an overview/map of as many of our applications dependencies as possible. Analyzing .NET application dependencies is fairly easy using tools such as NDepend (which I love!). But when it comes to external dependencies, such as dat

  • What do I use to make a simple html gallery? 2010-04-13

    i'm trying to make the typical ecommerce site where you have different views of clothing and when you click it it becomes the main image. I'm assuming javascript would be best suited for this? maybe Jquery will be easier? Thanks I just need someone t

  • Algorithm Analysis tool for java 2010-04-15

    I am looking for an algorithm analysis tool for java that can calculate Big 0 of a function. Ideal I would like to make it part of my build process, along side of my other code metrics tool. Even after searching on google I am unable to find any open

  • CVS tools for repo monitoring on windows? 2010-05-18

    I sometime use the very simple but effective svncommitmonitor, http://tools.tortoisesvn.net/CommitMonitor to monitor activity. It's easy to see in the sys tray on a windows box and I've become used to it by now. So, is there a similar/identical tool

  • Android JARSIGNER GUI tool? 2010-05-21

    Newbie question. After I have written the Android App (easy part) I need to sign it and upload it (seems the hard part) Is there an Open Source app or tool that I can use to do this so that I don't have to write command shell scripts. JARSIGNER looks

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.104 (s). 11 q(s)