lopcorporation.blogg.se - Free online database design tool

There are some that migrated from desktop, like Oracle SQL Developer, and some built for cloud from scratch, like Vertabelo Database Modeler. Recently, as most software, data modeling tools have moved to the cloud.

Don’t always handle changes correctly (can destroy metadata created after first import)Ĥ.

Rich ERD and data modeling capabilities.

They are also capable of reverse engineering and create a model out of live database. Designed to model data and design databases. They are mostly old, clunky, outdated, but they get the job done.

Easy online collaboration (in case of cloud tools).

Many of the tools in this category allow you to connect to your database, import database structure and generate diagram automatically. Recently, desktop tools have been challenged with online cloud tools, such as Lucidchart. Most popular tool in this category is MS Visio, part of MS Office family.

There’s a number of generic diagraming tools on the market that you can use to create all kinds of diagrams, like organization charts, UML diagrams, flow charts, mind maps and ER diagrams.

Generic Diagramming Tools (desktop / cloud) Not that easy to share, you need to take a picture to share with people outside of your officeĢ.Not that readable (depending on your hand writing).You know how to use it (from (pre)school).If your database has more than, say, 10 key tables then forget it and move on to the next section.ĮR diagram written manually on piece of paper Pros At least the first couple of entities are. You probably already have it on your desk. In this article I will present different categories of tools that you can use to create an ER diagram of your existing database to visualise its schema so that you can understand and communicate data you have.