DbSchema Blog

Categories

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

Best MySQL Database Design Tools in 2026: Buyer's Comparison

Seven MySQL design tools compared on engines, reverse engineering, offline use, documentation, Git and prices, with what each one does that DbSchema does not.

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

MySQL Default Username and Password | DbSchema

Find the real MySQL default root login behavior for 5.7, 8.0, and 8.4, reset passwords safely, and secure access faster with DbSchema.

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 Table Partitioning: Partition Functions, Schemes, RANGE LEFT/RIGHT, and Best Practices | DbSchema

Learn SQL Server table partitioning with partition functions, schemes, RANGE LEFT/RIGHT examples, list/hash alternatives, and DbSchema design tips.

Sql server • 05-Sep-2026

SQL Server User-Defined Functions (UDF) Guide with Examples | DbSchema

Learn how to create SQL Server user-defined functions in sqlcmd and DbSchema, including function types, permissions, syntax, and examples.

Sql server • 05-Sep-2026

SQL Server Insert Multiple Rows in a Single Query | DbSchema

Learn how to insert multiple rows in a single SQL Server query and avoid repetitive INSERT statements.

Design • 05-Sep-2026

SQL Server Data Compression: ROW vs PAGE vs COLUMNSTORE | DbSchema

Compare SQL Server ROW, PAGE, and COLUMNSTORE compression, estimate savings, and pick the right option for OLTP or analytics in DbSchema.

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 Distributed Transactions Guide with sqlcmd and DbSchema | DbSchema

Learn how SQL Server distributed transactions work, including permissions, transaction types, and practical execution in sqlcmd and DbSchema.

Sql server • 05-Sep-2026