dbForge Fusion for MySQL Features

• Integration with Visual Studio - dbForge Fusion for MySQL tightly integrates into your Microsoft Visual Studio. You can perform all tasks connected with MySQL database management and administration through your IDE using Devart add-in.
• MySQL Routine Debugger - dbForge Fusion for MySQL automates debugging by providing step-by-step code execution, breakpoints, watches, a call stack, and a variables evaluation mechanism. The tool can help you work with MySQL stored routines and triggers and keeps MySQL server's logic of procedure execution.
• MySQL Database Project - Work with databases offline. Compose a project, add various SQL and script files into it, group them into folders, and manage in one place. Build your project to a single script file or several ones and easily deploy on the server.
• Intelligent SQL Coding - Extended capabilities for code formatting and completion. Code snippets make writing code effective and fast. The add-in provides code navigation, quick object information, and syntax check.
• MySQL Query Profiler - Optimize multi-second queries by detecting problems and bottlenecks in them. Differences in query results are highlighted when you compare the results, so they can be easily seen and analyzed. Improve your queries, find and mend cracks in your database.
• Visual Query Builder - Build complex queries in several clicks. The tool features visual diagram and expression editor, it automatically adds joins between tables and allows working with INSERT, UPDATE, DELETE statements.
• Flat Table Editor - Table editor allows creating and modifying table structures and indexes visually. You can view changes exactly when you make them, and heuristics simplifies defining new column type.
• Visual Database Designer - Create, edit, analyze, reverse-engineer your MySQL databases visually with database diagram. It will help to easily perform routine tasks: observe database objects properties, see foreign key relations between tables, retrieve data, execute stored routines, etc.
• Database Comparison - Compare and analyze changes in your database data and schema, generate comparison reports. These features will help you to see the impact of changes made in a database and minimize the risk of applying unexpected and unplanned changes.
• Data Export/Import - Export and import data to/from more than 10 popular formats to fill your databases with new data. Customize the process and use templates to adjust the process.
• Integration with Devart dotConnect for MySQL - SQL code completion, advanced formatting and all other features of MySQL administration and management tool are available for users of Devart dotConnect for MySQL. Features for database management and administration will be embedded in your components as soon as the add-in is installed.

Standard Edition Includes

Integration

• Integration with Visual Studio
• Integration with dotConnect for MySQL

SQL Development

• MySQL stored procedure debugger
• Query Profiler
• Context-sensitive code completion
• Quick information about schema objects
• Parameter information for stored routines
• SQLcode formatting
• One step access to a schema object editor from code (go to definition)
• Visual Query Builder with support of SELECT statement
• Visual Query Builder with support of INSERT, UPDATE, and DELETE statements
• Visual Query Builder with support of sub-queries
• Quick INSERT statements generation from data grid without opening wizard
• SQL editor with syntax highlighting, bookmarks, and text searching
• Execution of scripts, selected SQL fragments, and statements
• Code Snippets
• Customizable DDL generation wizard
• Execution plan tool

Database Design

• Database Designer
• Dependencies lister
• Schema object searching on a live database
• Visual routine editors
• Flat table editor with heuristics support
• Partitioning support for table editor
• Object Viewer window for quick browsing of schema object properties

Administration

• Security Manager to administer user accounts and privileges
• Session manager
• Server Variables window
• Service control for starting and stopping MySQL servers
• Table maintenance wizard and flush dialog

Data Pump

• Database backup and restore wizards
• Data import wizard
• Data export wizard

Data Analysis

• Master-Detail Browser
• Data searching on a live database
• Data editor with in-place filtering, grouping, and sorting options

General

• Support for MySQL
• Support for MariaDB
• Support for SSL/SSH/HTTP connections
• MySQL pluggable authentication and Windows authentication on connecting to MySQL server
• Amazon RDS Support
• Support for Sphinx and Percona
• Work with MySQL embedded server
• Multiple database connections in Database Explorer window
• Connections coloring
• Dynamic help on MySQL accessible from the editor
• Enhanced visual data editor
• Shortcut customization
• Rich user settings
• Exporting/importing user settings

Professional Edition Additionally Includes

SQL Development

• Support for SQL refactoring
• Automatic SQL syntax check

Database Design

• Database Refactoring
• Schema comparison and synchronization tool
• Database project framework

Data Pump

• Data comparison and synchronization tool

Data Analysis

• Pivot tables
• Data reports