DbSchema is a good tool at a great price
Rating: 8 out of 10
IncentivizedUse Cases and Deployment Scope
This is a data modeling tool, used to generate accurate databases that implement correct data requirements. We gather the metadata as we go, so definitions and purpose information are captured. We can verify the design with test data generated from the tool, and can create web based pages to show the tables with data, customizable and simple to build.
Pros
- Many database platforms supported
- Direct database integration - option to have model actions reflected immediately in database.
- Test data generation with Groovy scripting for control over specific profiles
Cons
- Logical data model integration is weak. Need way to update existing models with changes
- Conceptual data modeling is missing
Likelihood to Recommend
Well suited to a team working directly in the physical modeling space.
MN
Michael Nicewarner
Data Architect in Information Technology at American Equity (1001-5000 employees)
Vetted Review
3 years of experience