TrustRadius: an HG Insights company

DbSchema

Score8 out of 10

1 Reviews and Ratings

What is DbSchema?

DbSchema, developed by Wise Coders GmbH, is a database design and management tool that aims to assist users in visually designing, documenting, and managing databases. It is claimed to be suitable for businesses of various sizes, ranging from small enterprises to large corporations. According to the vendor, DbSchema is utilized by professionals from different industries, including Database Administrators, Software Developers, Data Analysts, IT Consultants, and Web Developers, to streamline their database management processes.

Read more details.

Categories & Use Cases

Top Performing Features

  • Test data generation

    Generation of randomized or real-world test data

    Category average: 6.9

  • Schema maintenance

    Maintaining schema integrity via regular maintenance

    Category average: 8.7

  • Version control tools

    Version control tools ensure code integrity is maintained in a team coding environment

    Category average: 8.1

Areas for Improvement

  • Database security

    Security maintenance such as authorization management, log analysis, database auditing

    Category average: 8.6

  • Change management

    Automated scripts for implementing database changes

    Category average: 8.2

  • Performance optimization tools

    Performance optimization tools measure and maintain overall responsiveness and efficiency of queries, database structures, etc.

    Category average: 8.4

DbSchema is a good tool at a great price

Use 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

Return on Investment

  • DbSchema is very inexpensive, and functional, so easy to get a team started

Usability

Alternatives Considered

SAP PowerDesigner, erwin Data Modeler, IBM InfoSphere Data Architect and IBM Rational System Architect Designer