Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Your application code branches in seconds. Your database still gets copied, shared, and fought over. Here is how database branching closes that gap, where it breaks down, and what has to sit around it before it makes releases safer.
The post Database branching explained: How it works and when to use it appeared first on Devart Blog.
AI agents can already write SQL, inspect schemas, and work through multi-step database tasks. But what happens when they start acting inside the database itself. Read the full article to see where that shift leads, what still needs human control, and how database IDEs fit into the picture.
The post Will AI agents replace database IDEs? The future of database development appeared first on Devart Blog.
Visual Studio 2026 ships SQL projects through SSDT, and only the original project format. Here is how to configure, validate, version, deploy, and drift-check a database project without discovering the gaps during a release.
The post 13 best practices for database development in Visual Studio 2026 appeared first on Devart Blog.
This guide explains how to subtract days from dates across MySQL, H2, and other databases with different SQL dialects. Learn how to standardize behavior using compatibility modes, wrapper functions, and unified tooling so the same logic works reliably even when multiple database engines run side by side.
The post Mastering Cross-Database Date Manipulation: Subtracting Days in MySQL and H2 appeared first on Devart Blog.
Learn what data integrity in DBMS means, why it’s vital for database accuracy, and how to maintain it effectively. Read on to protect your data now.
The post Data Integrity in a Database: How to Ensure Accuracy and Security appeared first on Devart Blog.
One of the standout features of dbForge Studio is its ability to import data from various sources, including ODBC data. This significantly expands your capabilities, both for direct conversion of data stored on different platforms and for the convenient development of database-related objects such as ETL procedures, reports, and more.
The post How to Migrate From SQL Server to MySQL appeared first on Devart Blog.
In this guide, we are going to walk you through the process of transferring a database from a local machine or a traditional server to AWS with the help of the command line as well as with a convenient GUI - dbForge Studio for MySQL.
The post How to Migrate MySQL Database to Amazon RDS or Aurora appeared first on Devart Blog.
There's nothing quite like delivering regular feature-packed updates to our dear users—and we've got one for you today. dbForge tools for MySQL have been updated to version 10.1 with extended connectivity and quite a few new tricks to make your work easier and faster. To top it off, you get convenient CLI-powered generation of comparison reports.
The post Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1 appeared first on Devart Blog.
Read on to learn basics about invalid objects and how to identify them in SQL Server, MySQL, and Oracle databases using dbForge Edge or from the command line.
The post Find Invalid Objects in Your Databases appeared first on Devart Blog.
Last season was quite fruitful in terms of awards scored by our products on independent review platforms. And today, we've got a lot more of those to share. Without further ado, let's get started!
The post Champs Recap: Devart’s Award-Winning Products in Q1 2024 appeared first on Devart Blog.