All MySQL Tools You Need to Work with Data in Visual Studio
dbForge Fusion for MySQL is specially designed as Visual Studio plugin and serves as a MySQL connector for Visual Studio. In this page you will find a comprehensive listing of tools for MySQL database management and administration available in dbForge Fusion for MySQL. For a list of new features, see What's New in 6.2 .
Table of Contents
- Integration with Visual Studio
- MySQL Connectivity
- Administration and Maintenance
- Data Analysis
- Data Comparison and Sync
- Data Editor
- Database Backup
- Database Explorer
- Database Projects
- Database Refactoring
- Debugger
- MariaDB specific features
- Exporting and Importing Data
- Flat Table Editor
- Integration with dotConnect for MySQL
- Object Editors
- Query Builder
- Query Profiler
- Schema Comparison
- SQL Editing and Execution
- Visual Database Designer
- All database development and administration tasks available from your IDE
- SQL Editor, database object editors and other editors behave like usual IDE documents
- Help integrated into Microsoft Visual Studio .Net
- Support of Sphinx and Percona
- Support of all MySQL server versions 3.23-5.x
- Support of MariaDB
- Secure connections via SSL/SSH
- HTTP connections via PHP tunnel
- Support of UTF-8 databases
- Work with MySQL embedded server
- Direct access to MySQL server without client libraries
- Support of MySQL pluggable authentication when creating connection to MySQL server (PAM)
- Support of Windows authentication when creating connection to MySQL server
- Support of Amazon RDS
- Comprehensive Security Manager to administer user accounts and privileges
- Session manager for monitoring active MySQL server connections
- Service control for starting and stopping MySQL servers
- Table maintenance wizard for check, analysis, repair, and optimization of tables
- Server Variables window
- Server objects flush dialog
- Master-detail data browser
- Data report generation wizard
- Data report designer
- Pivot table designer
- Chart building wizard
- Data search on a live database
- Automatic data report generation and delivery to the requested destination
- Comparing and synchronizing data in databases of any size
- Optional view comparison
- Custom comparison keys support
- Option for BLOB data comparison
- Comparison results filtering
- Data synchronization script generation
- Per record viewing of data differences
- Exclude tables and records from synchronization
- Saving and loading of comparison settings
- Generating accurate comparison reports in HTML and Excel formats
- Comparison of custom query results (along with tables and views)
- Possibility to include objects into comparison by mask, which is useful when comparing groups of tables
- Asynchronous data fetch with ability to cancel the operation
- Batch table update mode when changes are accumulated and applied explicitly
- Copying data with column headers for quick paste to spreadsheet
- Custom data filters of any complexity
- Data Viewer window for browsing images, rtf, and binary cell values
- Date time editor with visual interface
- Foreign key lookup editor for easy editing of fields referencing other tables
- Free copying of any block of data to clipboard
- Full-text search (Ctrl+F) through data grid
- Graphical card view
- Grouping by arbitrary columns
- Incremental search (Ctrl+I) through data grid
- Large objects (LOB) editor
- Multi-table query result set editing
- Paginal data browsing for large result sets
- Printing of data
- Quick filter feature available for each data cell
- Record numbering option
- Read-only state indication
- Report, chart, and pivot building directly from data editor
- Server-side sorting and filtering to help dealing with large data sets
- Visible columns picking dialog box
- Comprehensive MySQL backup and restore wizards
- Schema or data only backups in addition to full backups
- Large database (exceeding 2 Gb) support
- Backup projects to save settings for future use
- Zip compression for backup files
- Error and status logging
- Multiple database connections allowed
- Asynchronous connect to server with ability to cancel the operation
- Detailed object properties and data browsing in Object Viewer window
- Dependency tree browsing for each object
- Duplicate object feature
- Quick template script generation for selected object: SELECT, INSERT, EXECUTE, etc
- Customizable DDL generation via wizard
- 'Send To' command for quick sending of tables to Query Builder, Data Report, and other tools
- Smart column renaming that allows rebuilding dependent tables
- Quick access to object privileges (GRANT) from the popup menu
- Multi-selection for batch operations on objects
- Database navigation history
- New project wizard with import from an existing database
- Project Explorer window for managing project files
- Schema View window for browsing logical project structure
- Project export into one script
- Reference checking while building
- Multiple build configurations
- Single-click project deployment on the server
- Code refactoring
- Schema comparison tool integration
- Workspace saving
- Renaming of tables, columns, views, procedures, and functions
- Preview of changes in the database with possibility to cancel them selectively
- Possibility to generate refactoring script of a database without changing it
- Refactoring feature can be accessed from Database Explorer and object editors
- Possibility to rename several columns from object editor
- If an error in processing dependencies is encountered, a user can fix it manually
- Stored procedure and function debugging
- Trigger debugging
- Script debugging
- Step Into, Step Over, and Step Out commands for step-by-step execution
- Breakpoints support for procedures, functions, triggers, and scripts
- Breakpoints window
- Call Stack window with navigation
- Watches window for variable evaluation
- Evaluation of session variables when debugging a script
- Single-click debug engine deployment
- SELECT (LIMIT ROWS EXAMINED) extended syntax
- INSTALL SONAME statement supported
- SHOW EXPLAIN syntax
- Multi-source replication syntax
- Dynamic Columns syntax for DML statements
- New KILL syntax
- Expanded CREATE TABLE or ALTER TABLE syntax
- Aria storage Engine supported
- Virtual columns supported
- Microseconds supported
- Pluggable Authentication supported
-
Data export to:
- CSV
- XML
- Text
- XLS
- DBF
- HTML
- RTF
- MDB (Access)
- ODBC
- SQL
- Export data from multiple tables at once
-
Data import from:
- CSV
- XML
- Text
- XLS
- XLSX
- DBF
- MDB (Access)
- ODBC
- Templates for exporting and importing
- Visual editor for tables
- Convenient editor for foreign keys
- Partitioning support
- Editable column grid: columns can be added and edited without opening the popup dialog
- Full-text search on the column grid
- Schema changes can be viewed before updating database
- Heuristics helps define data type of new columns
- Drag'n'drop objects onto form and dataset designers
- Component editors extended with additional commands
- Visual editors for columns, indexes, and views
- Visual editors for triggers, events, and user-defined functions
- Combined editors for stored procedures and functions
- Ability to browse schema objects in a single editor (pin document)
- Schema object search based on a variety of parameters
- The state-of-art diagram with zooming and keyboard support
- Preview and printing of the diagram
- Visual addition of sub-queries to any part of the main query
- Query outline (displayed in Document Outline window)
- Visual editing of sub-queries
- Expression builder for creating complex conditions
- Copy/Paste for tables on the diagram
- Undo/Redo support
- Saving queries to a file
- Support of visual building of INSERT, UPDATE, and DELETE statements
- Conversion of SELECT queries into INSERT statements
- One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE condition
- SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a UI
- Plan of the query displayed in the tree view for easy review
- Profiling history that can be saved for further analysis
- Compare profiling results feature with differences highlight
- Profiling results printing
- Option to compare a database with a database
- Option to compare a database with a project
- Schema comparison reports generation
- Synchronization between different server versions
- Comparison results filtering
- Schema synchronization script generation
- Per object viewing of DDL differences
- Objects exclusion from synchronization
- Saving and loading comparison settings
- Automatic SQL syntax check
- Code outlining with support of user-defined collapsing regions
- Code Snippet Wizard
- Context-sensitive code completion
- Context-sensitive dynamic MySQL help accessible from the editor
- Document Outline window for quick navigation through large scripts
- Execution of scripts, selected SQL fragments, and statements
- One step access to a schema object editor from code (go to definition)
- Parameter information for stored routines
- Quick access to favorite templates from SQL editor
- Quick information about schema objects
- SQL editor with syntax coloring, bookmarks, and text searching
- SQLformatting on-the-fly in the editor
- Executed SQL history window for the document
- Wizard for batch SQL formatting of files on the disk
- Visualization of tables, views, and stored routines
-
Easy access to database objects for viewing their properties, editing, retrieving
data,
executing stored routines, etc. - Support for IDEF1X and IE notations
- Customizable diagram look and feel with skin support
- Smart diagram layout
- Diagram export to different image formats
- Searching database objects on diagram
- Organizing diagram shapes with containers
- Customizable diagram printing with a rich set of options
- Optional displaying of table constraints, indexes, and triggers
- Integration with Document Outline window
- Diagram navigation with Diagram Overview window
- Notes for adding your comments to the diagram