<p>We are using PowerDesigner at work for database modelling. But there is a hell of a price tag on that piece of software. And frankly, all I use is physical diagrams for MS SQL, which is about 1% of what PD knows.</p>

<p>Are there any good alternatives? I know about Visio and MS SQL Diagrams, but looking for other options.</p>

[{'answer_id': 76572, 'author': 'digiguru', 'author_id': 5055, 'author_profile': 'https://Stackoverflow.com/users/5055', 'pm_score': 2, 'selected': True, 'text': "<p>I just use SQL Server using the diagrams folder. The designer is pretty simple to use, and can be used to generate tables fairly quickly. Considering it's free with the software, I don't see the issue.</p>\n"}, {'answer_id': 76653, 'author': 'SarekOfVulcan', 'author_id': 2531, 'author_profile': 'https://Stackoverflow.com/users/2531', 'pm_score': 0, 'selected': False, 'text': '<p>You might want to look at <a href="https://www.xcase.com/demo.php" rel="nofollow noreferrer">https://www.xcase.com/demo.php</a>. It\'s not free, but it\'s quite a bit cheaper than PowerDesigner, as far as I can tell. I\'ve used earlier versions, but lately I\'ve had easy access to Visio, so have continued with that instead of investing in xCase.</p>\n'}, {'answer_id': 81330, 'author': 'ConcernedOfTunbridgeWells', 'author_id': 15401, 'author_profile': 'https://Stackoverflow.com/users/15401', 'pm_score': 0, 'selected': False, 'text': "<p>The version of Visio that comes with VS Enterprise Architect has a forward-engineer feature that will generate SQL.  There is also a type library for the modelling engine, but (on older versions at least) it won't extract certain items such as comments.  However, the generated SQL has the comments in a fairly simple structure that does facilitate parsing the generated SQL.</p>\n\n<p>You can get older versions of VS enterprise architect on E-bay for not very much money (I think mine cost about £250).</p>\n\n<p>One caveat for reverse-engineers is that all pre-VS2005 visio DB modelling engines will not play nicely with the SQL Server 2005 native client.  You need to either script out the database and re-load it on a SQL2000 server (dealing with SQL2005 specific features such as schemas is left as an exercise for the reader) or get a more recent version.</p>\n"}, {'answer_id': 141646, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 0, 'selected': False, 'text': "<p>Well there's another alternative. Use it for more than just making tables! Exploit it, get your money's worth. You've already paid for it, you could drop the maintenance and just use it as-is. Anyways, something to ponder.</p>\n"}, {'answer_id': 141679, 'author': 'Huuuze', 'author_id': 10040, 'author_profile': 'https://Stackoverflow.com/users/10040', 'pm_score': 4, 'selected': False, 'text': '<p><a href="http://www.sqlpower.ca/page/architect" rel="noreferrer">Power*Architect</a> is the way to go.  It\'s free, open source, and does a really great job helping you build your ERDs.  Plus, it works on Windows, Linux, and OSX.</p>\n'}, {'answer_id': 3474842, 'author': 'Flaunt', 'author_id': 419301, 'author_profile': 'https://Stackoverflow.com/users/419301', 'pm_score': 2, 'selected': False, 'text': '<p>Open System Architect: www.codebydesign.com - it does job for me perfect</p>\n'}, {'answer_id': 3578795, 'author': 'J. Coughlin', 'author_id': 432262, 'author_profile': 'https://Stackoverflow.com/users/432262', 'pm_score': 1, 'selected': False, 'text': '<p>SourceForge.net Druid project</p>\n\n<p>Has a templating engine to produce DDL or what ever you like.\nHas the ability to have multiple diagrams in one model.\nOnly does physical data model.\nIt is free and has source available.\nIt is a java based tool so it will run on Unix or Windows.</p>\n'}, {'answer_id': 3999554, 'author': 'Brian Taylor', 'author_id': 484516, 'author_profile': 'https://Stackoverflow.com/users/484516', 'pm_score': 2, 'selected': False, 'text': '<p>Check out Sparx Enterprise Architect also.</p>\n'}, {'answer_id': 6718379, 'author': 'mixtly87', 'author_id': 824052, 'author_profile': 'https://Stackoverflow.com/users/824052', 'pm_score': 1, 'selected': False, 'text': '<p>How about MagicDraw? It is a very powerfull tool, but I think it as expensive as PowerDesigner, not sure.</p>\n'}]
['https://Stackoverflow.com/questions/76350', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/11063/']