dbForge Studio for MySQL features
Intelligent SQL Coding
Bring convenience and effectiveness to your daily SQL coding with intelligent code completion, flexible formatting, code snippets, simplified code navigation, quick object information, and instant syntax validation. Using all of these features in the integrated MySQL Code Editor, you can double your regular coding speed in no time.
Using dbForge Studio for MySQL, you can set up and streamline effective version control of database schemas and static table data.
- Commit and revert changes
- Perform fast comparison of database versions
- View and resolve conflicts
- Scrutinize the history of changes
Fill MySQL databases with external data using our export and import tools. They support more than 10 popular data formats and allow customizing the whole process. In addition, you can create and modify handy templates as well as automate recurring data import and data export tasks from the command line.
Transfer MySQL Server databases from one server instance to another with a nifty feature called Copy Databases, which helps you do the following:
- Customize copying settings
- Copy databases together with data
- Drop a database if it already exists on the target server
Use convenient database diagrams for creating, analyzing, reverse-engineering, printing, and customizing your MySQL databases.
- View foreign key relations
- Display database objects with their properties
- Execute stored routines
Populate your MySQL tables with thousands of rows of realistic test data. The integrated Data Generator supports all MySQL data types, includes a large number of meaningful generators with customizable settings, and allows generating data from the command line.
Visual Query Builder
Create queries visually using diagrams and use the expression editor to set query criteria. Queries of any complexity can be created in several seconds. Query Builder automatically adds JOINs between tables and allows working with INSERT, UPDATE, DELETE statements.
The Studio delivers a visual designer for creating and modifying creating table structures, indexes, primary keys, defaults, and CHECK constraints. Get full control over the changes you have made. The built-in heuristics feature will suggest a column type on creating a column based on the name you are entering.
Improve MySQL database design by applying small changes. When such changes are performed, they are fully transparent, and the Studio takes care of all dependencies in the database:
- Rename database objects with preview
- Perform script refactoring
Dump databases in the SQL format and schedule regular database backups. Use 5 levels of file compression and wide set of options to fine-tune your backups. Additionally, you can save your settings and connections as a reusable project.
The Studio delivers a set of variegated tools that make MySQL database administration nearly effortless.
A database project is a collection of logically organized SQL scripts and query files, which are used both to create new databases and to update existing ones. Database projects can be created from scratch or imported from a database. They offer a lot of features that propel quick and convenient database development.
dbForge Studio includes a tool for quick generation of comprehensive database documentation. Here's what you can do with its help:
- Retrieve an overview of the database structure
- View inter-object and inter-database dependencies
- Customize documentation with style templates
- Generate documentation in HTML, PDF and Markdown
dbForge Studio for MySQL provides several ways to migrate databases either within the same instance or between different instances, including the following:
- Copy databases
- Backup and restore databases
- Import and export data to multiple formats