The database designer, with good visualization and working with the database?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
10 views
Interested to know what program created today, and how many buns which of them is the main criteria, there are not many, the visualization of the database model, a direct work from the model to the base (or as in MySQL Workbench where the model comes as a single project, and with the base to work the other), and support for MySQL or PostgereSQL.
by | 10 views

5 Answers

0 like 0 dislike
DbVisualizer — as the name implies, is able to draw the model. Works with all databases having a JDBC driver. Tabular data editor and model, query builder, sql monitor, auto-completion in the editor and stuff like that. Well, all of my databases only and it happens.
Of the shortcomings — in sql editor not working anti-aliasing of the font :), I'm not remember.
by
0 like 0 dislike
Use the products by EMS (EMS Mysql manager 2010 EMS MSSQL Manager 2008). Comfortable working with sql queries, syntax highlighting, visual editor, database, export to a huge variety of formats, dump, data visualization tables in several modes and much more.
by
0 like 0 dislike
If to talk about free, that there is such a serious decision as Oracle BI:
\r
Oracle Business Intelligence (BI) is the most comprehensive set of technologies and applications to ensure the submission of internal business organization, including leading BI applications, BI technology platform and data warehouse. Ranking first in the market of business Analytics, Oracle BI enables companies and organizations to gain complete and timely insight into the inner structure, to provide a comprehensive distribution of the analytical data and implement more effective processes and actions. Oracle BI solution is compatible with Oracle and non-Oracle environments so customers can fully leverage existing data sources, systems and applications. At the same time, due to the complex of integrated and optimized solutions pre-configured to work with databases, software, middleware and Oracle applications, organizations can reduce software cost and to take advantage of a vast and unified BI infrastructure.
\r
by
0 like 0 dislike
For designing the database, we use Toad Data Modeller version 2.25. Version 3.+ they messed up, unfortunately (although others think otherwise:). In version 2.25 — normal interface, draws good shemki.
To work with databases — EMS SQL Manager, it is better, perhaps, not seen.
by
0 like 0 dislike
I found only one solution for drawing the diagram on DDL or with a connection to the database. DbSchema www.dbschema.com/index.html
However on request I have somehow not reached all the connections (PostgreSQL), but there was another option - connecting to the database. I executed this query, create schema, connect, and done! Next is just positioning rectangles with tables as you would like. In pictures and even in vector svg more suitable for printing. And to add SVG in Word, you need to open Incsckape and keep emf or arbitrarily large transparent PNG.
by

Related questions

0 like 0 dislike
6 answers
0 like 0 dislike
4 answers
asked Mar 23, 2019 by unkinddragon
0 like 0 dislike
2 answers
asked Jun 4, 2019 by Konstantin18ko
0 like 0 dislike
3 answers
asked May 21, 2019 by Convaallaria
110,608 questions
257,186 answers
0 comments
28,003 users