Connect and Manage MySQL with a Visual Studio Add-in

Integration with Devart 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.

Drag & Drop from Database Explorer to WinForms

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.

Code completion and syntax check

Improve code writing, quality, and accuracy with code completion and syntax checker that include:

• Code snippets
• Context-based code completion
• Object and keyword suggestion
• Alias management
• Highlighting errors

Code formatting

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

• Built-in formatting profiles
• Bulk formatting
• Preview of the formatted code
• Switch between formatting profiles
• Automate and schedule formatting tasks from the command line

MySQL Routine Debugger

dbForge Fusion for MySQL automates debugging by providing step-by-step code execution, breakpoints, watches, a call stack, and a variable evaluation mechanism. It also helps you to work with stored routines and triggers and keeps MySQL server's logic of procedure execution.

Object editors

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.

Data Import

The MySQL plugin for Visual Studio provides the Data Import wizard that helps you import data from multiple tables in a variety of popular formats, as well as create templates with import settings for future use.

Data Export

dbForge Fusion for MySQL provides the Data Export wizard that helps you export table data to a variety of popular formats and save export configuration templates for later use.

Schema Comparison

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
• Filter comparison results
• Exclude objects from synchronization
• Save templates with comparison settings
• View DDL differences per object
• Generate a schema synchronization script

Data Comparison

dbForge Fusion for MySQL helps you compare and detect data differences between two MySQL databases.

• Generate a schema synchronization script
• Synchronize data using the command-line interface
• Support for custom comparison keys
• Filter objects in data comparisons
• Fine-tune comparison results
• Export comparison results