dbForge Studio for MySQL simplifies the management, administration, and development of databases in MySQL and MariaDB. Its advanced features make working with data and code easier and more convenient.
One of the standout features of this software is its broad compatibility with a range of systems, including MySQL, MariaDB Server, Percona, Galera Cluster, Amazon RDS, and Google Cloud. In addition, its intelligent SQL coding capabilities can enhance your workflow with code completion, formatting, code snippets, and more.
Other notable features include schema and data comparison and synchronization, a data generator which supports all MySQL data types and can be used via the command-line interface, and a visual query builder with a diagram and expression editor. The tool also automatically adds joins between tables and allows for working with INSERT, UPDATE, and DELETE statements.
To complete your database development and deployment, dbForge Studio offers database backup, administration, and documentation generation in HTML, PDF, and Markdown. There is also support for check constraints, a table designer, query profiler, database refactoring, and even database projects.
With its MySQL debugger, you can also automate the debugging of your stored routines and procedures with step-by-step code execution, breakpoints, watches, a call stack, and a variables evaluation mechanism. Finally, you can copy databases with ease to ensure data integrity and continuity.
All in all, dbForge Studio for MySQL is a powerful and versatile software suite that can streamline and enhance your database development and management workflows.
Version 9.0.304: The 9th version delivers completely new functionality, including Find Invalid MySQL Objects, provides new connectivity options, and contains massive improvements of existing features, including MySQL Data and Schema Compare, Data Import and Export. Activation can now be done via the command-line.
Version 8.2: * Support for Check Constraints for MySQL
Version 8.1: *Support for MariaDB 10.4
Version 8.0: *Support for MySQL Server 8.0 *Support for MariaDB 10.3 *Support for Tencent Cloud *Code Completion (Jump between Syntax Pairs) *And more
Version 7.4: *Google Sheets feature for easy migrating table data between MySQL tables and Google Spreadsheets*Enriched SQL documents management with Execution notifications and Transaction Reminder as well as highlighted current code line*Enhanced Code Completion with dozens of variables and functions*And more
Version 7.3:
Enterprise Edition
Data Generator allows instant generation and database population with meaningful test data
Database Documenter allows database documentation generation in HTML, PDF, and Markdown file formats
Use Copy Database for copying a set of databases without generating and running a script
Version 7.2:
The Database Search tool has been completely redesigned for optimal search of both objects and data
Visual Object Editors have been totally redesigned
Redesigned Table Maintenance wizard
Improved SQL document parser performance
Connection through Named Pipe implemented
Improved XML View and new JSON
Version 7.1:
*Data type information to the column header in Data Grid added
*Data Grid now supports Generate Script As feature
*Generate Script As now available for multiple objects in Database Explorer
Version 7.0:
- Support for MySQL 5.7
- Support for the PASSWORD EXPIRE option in Security Manager
- Support for computed columns
- Support for the JSON Data Type
- Support for Spatial Indexes
- Support for Percona PAM authentication
- Support for the Amazon Aurora connection
- Improved code refactoring
Version 6.3:
- Phrase Completion
- Enhanced Command-Line Interface
- Improved Data Export and Import
- More Options to Customize Data Comparison and Sync