Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models, propagate changes from one model to the other in both directions, create database scripts, and reverse-engineer databases.
However, not all data modeling tools are equal. It is the advanced yet critical features that separate a suitable data model from an excellent data model.
Here are four features that distinguish ER/Studio Data Architect from the rest of the data modeling tools in the industry:
- Roll down table into multiple child tables
ER/Studio can roll down a table into several child tables in a single operation.
- Link transformations back to logical data models
ER/Studio remembers the transformations that you carry out while denormalizing physical data models. It links the transformations back to the objects of the logical data model and can display the state of the model before and after the transformation.
- Logical and physical data models data lineage
ER/Studio can record data lineage for database migrations in both logical and physical data models. This allows users to model high-level designs for data movements.
- View data lineage graphically
ER/Studio can represent information concerning the data lineage for database migrations as diagrams in the graphical user interface.
View this web page to see more unique features of ER/Studio Data Architect that make it the best data modeling tool.
The best way to learn more about how ER/Studio can help you and your organization is to download a free, fully functional, 14-day trial. You do not need to provide any credit card information.
You can also schedule a personalized product demonstration with an IDERA industry expert.