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.
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!
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.
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.
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.
MySQL Editor for Visual Studio
The Data Editor allows you to view, sort, group, and edit data right in the grid.
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.
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.
Visual Studio Database Projects for MySQL
Create, save, open database projects, and import database objects into them.
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.
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.
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.
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.
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
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.
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.
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
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
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
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.
