DbSchema Blog

Categories

• Cassandra
• Databases
• Dbschema features
• Design
• Firebird
• Migrations
• Mongodb
• Mysql
• Oracle
• Postgresql
• Release notes
• Snowflake
• Sql server
• Sqlite
• Tool comparisons
• Tools
• Tutorials

MySQL Workbench Alternatives for Multi-Engine Teams

Compare the top MySQL Workbench alternatives for 2026, including DbSchema, DBeaver, and dbForge Studio, with detailed pricing and feature trade-offs.

Tools • 20-Aug-2026

Data Dictionary Tools Compared: An Architect Guide

Compare the top data dictionary tools, including DbSchema, Dataedo, and Alation, to find the right metadata repository for your stack.

Tools • 20-Aug-2026

SQL COUNT, AVG, and SUM with GROUP BY: Syntax and Examples | DbSchema

COUNT(*) counts every row including NULLs, COUNT(column) skips them, and SUM and AVG ignore NULL. SQL COUNT, AVG, SUM syntax with GROUP BY and HAVING.

Tutorials • 19-Aug-2026

SQL TOP, LIMIT, FETCH FIRST, and ROWNUM Explained | DbSchema

SQL TOP, LIMIT, FETCH FIRST n ROWS ONLY and ROWNUM compared engine by engine: syntax, worked examples and the pagination form for each.

Tutorials • 19-Aug-2026

MongoDB Create Database – mongosh, Atlas, Compass, Docker, and DbSchema | DbSchema

Create a MongoDB database with use and a first insert in mongosh, or through Atlas, Compass, Docker and DbSchema. Why an empty database does not persist.

Mongodb • 19-Aug-2026

Comparing Production and Staging Schemas

Learn how to compare production and staging database schemas, identify hidden schema drift, and use DbSchema to generate precise visual migration scripts.

Migrations • 19-Aug-2026

Comparing Two Database Schemas

How to compare two database schemas and generate safe DDL migration scripts, with DbSchema Pro, Microsoft SSDT and Redgate SQL Compare for SQL Server.

Migrations • 19-Aug-2026

Turning a Schema Diff Into a Safe Migration Script

How database administrators turn a schema diff into a migration script: version the XML design model in Git, generate the DDL, review it before it runs.

Migrations • 19-Aug-2026

SQL UPDATE Statement: Syntax, Examples, and Safe Patterns (2026) | DbSchema

Learn SQL UPDATE syntax with practical examples, WHERE safety checks, JOIN-based updates, and transaction-safe patterns for MySQL, PostgreSQL, and SQL Server.

Tutorials • 18-Aug-2026

Visual Schema Diff or a Code-Only Migration Library

Compare code-only migration libraries with visual schema diff tools. Learn how to version XML models in Git and generate migration scripts automatically.

Migrations • 18-Aug-2026