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 CREATE TABLE Guide with Examples | DbSchema

Learn how to create tables in MySQL with SQL commands, prerequisites, and visual design steps in DbSchema.

Mysql • 05-Sep-2026

Documenting a MySQL Database

Learn how to generate interactive MySQL database documentation. Compare top tools, explore the four documentation types, and export HTML5 docs.

Mysql • 05-Sep-2026

SQL Server Window Functions Guide with Examples | DbSchema

Learn SQL Server window functions with practical examples in sqlcmd and DbSchema, including ranking, aggregates, value functions, and common limitations.

Sql server • 05-Sep-2026

SQL Server Schema Comparison Tools

Compare SQL Server schema comparison tools: DbSchema, Redgate SQL Compare, dbForge and xSQL, with the price each vendor lists today and what each compares.

Sql server • 05-Sep-2026

SQL Server Stored Procedure Tutorial with sqlcmd and DbSchema | DbSchema

Learn how to create stored procedures in SQL Server using sqlcmd and DbSchema, including syntax, permissions, examples, and best practices.

Sql server • 05-Sep-2026

SQL Server Database Normalization Techniques in sqlcmd and DbSchema

Learn SQL Server database normalization from 1NF to 6NF: what breaks each normal form, the sqlcmd fix, and how to check the result in DbSchema.

Sql server • 05-Sep-2026

Design SQL Server Schemas Visually with DbSchema

Design and organize your SQL Server database visually using diagrams that clearly show tables, relationships, and help you understand the structure.

Sql server • 05-Sep-2026

Schema Versioning for SQL Server

Put SQL Server schema versioning in Git: DbSchema keeps the design model as plain XML and generates the T-SQL migration script between two versions.

Sql server • 05-Sep-2026

SQL Server MERGE to Update, Insert, and Delete Rows | DbSchema

Learn how to use SQL Server MERGE to update, insert, and delete rows by matching source and target tables.

Design • 05-Sep-2026

SQL Server Replication Setup Guide with sqlcmd and DbSchema | DbSchema

Learn how to set up SQL Server replication with sqlcmd, understand replication roles and types, and validate replicated data in DbSchema.

Sql server • 05-Sep-2026