All features that you really need!
Share database models by simply providing team member's email and
clicking a button. You can share model at three different access levels:
Owner, Editor and Viewer. Access levels can be changed at any time.
Working on a model at the same time
Everyone who shares a model may open it at the same time. When
the model is opened for editing for one person, it is read-only for
others. Everyone can see changes in the model just after an autosave.
Public link to the model
If you need to share model with your customers or partners they may
not be interested in having an account in Vertabelo. In this situation,
you can create the public link to your model and send it via e-mail.
To speed up navigation over a large model, you can use the fast
navigation component. It's a map of the model which allows you to
move quickly from one part of model to another.
Find in diagram
Find an element in the navigation tree and click find in diagram.
The element you searched for is highlighted and the diagram view will
be refocused to center on that element.
Subject areas are named and represented by a smart rectangles.
They indentify the tables, views,
references and notes contained within.
- Instant save
The database model you are working on is saved automatically several
times a minute. If someone has the model open in read-only mode
they can see the changes you made in the last minute.
- Live validation
Vertabelo validates your model all the time and gives you hints on how
to improve it. Every error, warning or tip is flagged by a dedicated icon
that you can see on the tree representing the model structure.
- SQL preview
At any moment you can see a preview of the SQL that will be generated
for a selected element. Just click on the SQL preview button on
the properties panel.
Copy - Paste
Vertabelo has a Copy - Paste feature accessible from the menu as well
as from keyboard shortcuts (CTRL + C, CTRL + V). The Fast switch
function allows you to copy elements from others models.
Most operations in the diagram editor can be performed
directly from the keyboard. To see all the keyboard shortcuts
just press CTRL + I.
Well-organised properties panels
Some elements of a database model have a complex structure.
Vertabelo provides a clean, well-organised properties panel to
simplify editing of database model elements.
At any time you can generate an SQL script that:
- creates all elements in your database.
- removes all elements from your database.
- creates or removes only selected elements – constraints for example.
Vertabelo checks your model before SQL script generation and notifies you of any errors or warnings. You have the flexibility to ignore the warnings and generate the SQL anyway or go back and correct the model.
- Import an existing database
You can import an existing database into Vertabelo using a simple
command-line tool that you can download from our website.
The tool is provided as a command-line Java application which
you run on your computer. You don't give us your database
credentials nor do we make a connection to your database.
- Automatic diagram layout
The Reverse Engineering tool lays out the database diagram
automatically, so you'll have to manually adjust your diagram in
Vertabelo. We're working on a more sophisticated algorithm for
a future release.