MySQL Developer and Manager Tools for Visual Studio in One Extension

MySQL Visual Studio Integration

A MySQL plugin for Visual Studio designed to automate and simplify MariaDB and MySQL database development and enhance data management capabilities. When you integrate it, all database development and administration tasks become available from the Visual Studio.

dbForge Fusion for MySQL - MySQL Visual Studio Integration

MySQL Connection Compatibility

dbForge Fusion supports MySQL server versions 3.23, 4.0, 4.1, 5.x, MariaDB server versions 5.5, 10.0, Visual Studio (2010, 2012, 2013, 2015, 2017, 2019) and more!

More on Connectivity and Compatibility

dbForge Fusion for MySQL - MySQL Connection Compatibility

Visual Studio Management Tools for Administrator

Everything you might need for MySQL server administration is here. Keep a close eye on user accounts and privileges with Security Manager, manage sessions, monitor active MySQL server connections in real time.

dbForge Fusion for MySQL - Visual Studio Management tools for Administrator

MySQL Data Analysis in Visual Studio

Group, sort, and analyze data from the different angles in Master-Detail Browser to see the whole picture and optimize it according to your needs and preferences. Convert large amounts of data into easy-to-percieve Pivot Tables. And finally, automate data report generation to improve your experience even more.

dbForge Fusion for MySQL - MySQL Data Analysis in Visual Studio

Compare and Synchronize Data from Different Sources

With the tool, you can easily compare, analyze, and synchronize changes in MySQL databases and, thus, minimize the risk of applying unexpected and unplanned changes.

dbForge Fusion for MySQL - Compare and Synchronize Data from Different Sources

MySQL Editor for Visual Studio

The Data Editor allows you to view, sort, group, and edit data right in the grid.

dbForge Fusion for MySQL - MySQL Editor for Visual Studio

Backup Database Files

With dbForge Fusion for MySQL you can perform database backup easily using the Database Backup Wizard. Fusion for MySQL backs a database up into a simple SQL script.

dbForge Fusion for MySQL - Backup Database Files

Visual Studio Database Explorer for MySQL

You can easily drag database objects, including tables, stored procedures, and views, from Database Explorer to WinForms, WEB-Forms, Datasets, etc. The IDE automatically creates a SQL script of the component, which you can execute and view the result on the grid.

dbForge Fusion for MySQL - Visual Studio Database Explorer for MySQL

Visual Studio Database Projects for MySQL

Create, save, open database projects, and import database objects into them.

dbForge Fusion for MySQL - Visual Studio database projects for MySQL

Database Refactoring Tools

With the dbForge MySQL refactoring functionality you can perform smart structural refactorings - rename columns, tables, and/or views with the purpose to increase code readability or adopt database naming conventions.

dbForge Fusion for MySQL - Database Refactoring Tools

Debug Tools

MySQL debugger built into dbForge Studio for MySQL allows debugging stored procedures quickly and easily using traditional debugging operations such as setting breakpoints, viewing variable values, examining the call stack, etc.

dbForge Fusion for MySQL - Debug Tools

MariaDB Specific Features

Some features are available for the MariaDB connections only:

  • SELECT (LIMIT ROWS EXAMINED) extended syntax
  • INSTALL SONAME statement
  • Multi-source replication syntax
  • Dynamic Columns syntax for DML statements
  • Aria storage Engine
  • Pluggable Authentication

dbForge Fusion for MySQL - MariaDB specific features

Database Data Export/Import

The MySQL plugin for Visual Studio provides the Data Import and Export wizards that help you interact with data in different tables in a variety of popular formats, as well as create import/export templates for future use.

dbForge Fusion for MySQL - Database Data Export/Import

Flat Table Editor

The tool displays a grid where you can easily create columns and manage their attributes without opening any pop-up windows. You can preview the changes before applying them to the database. Heuristics helps define data type of new columns.

dbForge Fusion for MySQL - Flat Table Editor

Integration with dotConnect for MySQL

SQL code completion, advanced formatting and all other features of our MySQL administration and management tool are available for users of Devart dotConnect for MySQL. Database management and administration features will be embedded in your components as soon as the MySQL Visual Studio add-in is installed.

More on dotConnect for MySQL
dbForge Fusion for MySQL - Integration with dotConnect for MySQL

Visual Studio Object Editor

dbForge Fusion for MySQL helps you create, modify, and manage different database and table objects visually. The MySQL tool for Visual Studio provides multiple object editors for columns, indexes, views, triggers, events, user-defined functions, stored procedures, and functions.

In addition, you can search for a specific object based on a set of parameters or access a schema object editor from the code.

dbForge Fusion for MySQL - Visual Studio Object Editor

Query Builder

Query Builder is designed to enhance productivity and simplify SQL query building tasks. Query Builder provides a graphical user interface for creating SQL queries. You can drag-and-drop multiple tables, views and their columns onto a visual designer to generate SQL statements.

dbForge Fusion for MySQL - Query Builder

Query Profiler

Query Profiler will come in handy when optimizing SQL queries:

  • Results and variables are displayed in a UI
  • Save profiling history for further analysis
  • Prinit profiling results

dbForge Fusion for MySQL - Query Profiler

Visual Studio Schema Compare

With the tool, you can easily compare, analyze, and synchronize changes in MySQL database schemas and, thus, minimize the risk of applying unexpected and unplanned changes.

  • Generate comparison reports
  • Exclude objects from synchronization
  • Save templates with comparison settings
dbForge Fusion for MySQL - Visual Studio Schema Compare

Visual Studio SQL Code Formatter

With dbForge Fusion for MySQL, you can easily configure custom formatting options and rules to improve code readability. The formatting capabilities include:

  • Built-in formatting profiles
  • Bulk formatting
  • Preview of the formatted code
  • Switch between formatting profiles
dbForge Fusion for MySQL - Visual Studio SQL Code Formatter

MySQL Designer for Visual Studio

The tool grants easy access to database objects for viewing their properties, editing, retrieving data, executing stored routines. By visualizing tables, views, and stored routines, dbForge Fusion brings the user closer to their database.

dbForge Fusion for MySQL - MySQL Designer for Visual Studio