What program is best for drawing a database schema?

O

Oleg2014-03-31 09:13:09

SQL

Oleg, 2014-03-31 09:13:09

I design a database on MS SQL. The project is described in Excel, but I want to visualize it all.
The main part is already programmed along with the foreign keys.
What is the most convenient and clear way to describe the database?

Reply

Answer the question

In order to leave comments, you need to log in

7 answer(s)

A

Alex Db, 2014-03-31
@alexdb

Free: mysql workbench
Online: dbdsgnr

S

Sergey Nikolaevich, 2014-03-31
@Playmore

dbForge Studio for SQL Server

V

v_prom, 2014-03-31
@v_prom

https://www.draw.io/

A

afiskon, 2014-04-05
@afiskon

www.dbschema.com - good. is inexpensive.

A

Artem Voropaev, 2014-03-31
@Legolas

Well, if the task is just to draw, then the good old ErWin))
In general, I strongly advise you to get acquainted with the Sybase Power Designer product - a powerful tool and visualizer and programming, even from an existing database. Supports quite a lot of DBMS.

L

lavcoder, 2014-10-31
@lavcoder

And why do not you like the possibilities of Management Studio itself?

J

Jo_mikoliev, 2022-03-10
@Jo_mikoliev

By far my favorite data modeling tool is ERBuilder . it is very easy to use, you can master it in less than 5 minutes thanks to its intuitive interface. It supports multiple DBMS including MS SQL Server. There is a free version of the tool, otherwise you can use the commercial version for a trial period (15 days I think).