dbForge Fusion for MySQL Features

Integration with the most popular IDEs

• 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 and CodeGear RAD Studio

Integration with dotConnect for MySQL and MyDAC

• Drag'n'drop objects onto form and dataset designers
• Component editors extended with additional commands

MySQL Connectivity

• Multiple database connections in Database Explorer window
• Asynchronous connect to server with cancel feature
• Support of all MySQL server versions 3.23-6.0
• Direct access to MySQL server without client libraries
• Support of UTF-8 databases
• Support of SSL/SSH/HTTP connections
• Work with MySQL embedded server

Schema Object Management

• Visual editors for tables, columns, indexes, and views
• Convenient editor for foreign keys
• Partitioning support in a table editor
• 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)
• Duplicate object feature
• Customizable DDL generation wizard
• Schema object search based on a variety of parameters
• Summary window for quick browsing of schema object properties
• Data search on a live database
• Multi-selection in Database Explorer for batch operations on schema objects

Advanced SQL Editing

• SQL editor with syntax coloring, bookmarks, and text searching
• Code outlining with support of user-defined collapsing regions
• Navigation bar for jumping between object definitions within one document
• Document Outline window for quick navigation on large scripts
• Code templates library
• Quick access to favorite templates from SQL editor
• Context-sensitive code completion
• Parameter information for stored routines
• Quick information about schema objects
• One step access to a schema object editor from code (go to definition)
• Automatic SQL syntax check
• SQL formatting on-the-fly in editor
• Wizard for batch SQL formatting of files on disk
• Dynamic help on MySQL accessible from the editor

SQL Execution and Data Management

• Execution of scripts, selected SQL fragments, and statements
• Execute Script Wizard for quick and convenient execution of large SQL scripts
• Executed SQL history
• Asynchronous execution with cancel feature
• Execution plan tool
• Transaction support
• Data editor with in-place filtering, grouping, and sorting options
• Paginal data access for large result sets
• Graphical card view for data editor
• Large objects (LOB) editor
• Text search in data editor
• Data printing
• Ability to postpone sending of data updates to the server (Cached updates mode)
• Data export wizard
• Customizable data export to widely-used formats: CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, and XML

Database Designer [New]

• Visualization of tables, views, and stored routines
• Easy access to database objects to view and edit their properties, retrieve data, execute 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

Visual Query Builder

• The state-of-art diagram with zooming and keyboard support
• Preview and printing of the diagram
• Query outline (displayed in Document Outline window)
• Visual editing of sub-queries
• Copy/Paste for tables on a diagram
• Expression builder for creating complex conditions
• Undo/Redo support
• Saving queries to a file

Stored Routine and Script Debugging

• Support of procedures, functions, and triggers
• Single-click debug engine deployment
• Step-by-step execution
• Breakpoint management
• Call stack navigation
• Watches window for variable evaluation
• Evaluation of variables when debugging a script

Server Administration and Maintenance

• Security Manager to administer user accounts and privileges
• Quick access to object privileges from Database Explorer
• Schema export and import wizards
• Table maintenance wizard for check, analysis, repair, and optimization of tables
• Server objects flush dialog
• Session manager
• Service control for starting and stopping MySQL servers
• Server Variables window

Schema Comparison and Synchronization

• Ability to compare a database with a database
• Ability to compare a database with a project
• Synchronization between different server versions
• Comparison results filtering
• Schema synchronization script generation
• Per object viewing of DDL differences
• Objects exclusion from synchronization
• Save and load comparison settings

Data Comparison and Synchronization

• Comparison of large tables
• Optional view comparison
• Custom comparison keys support
• Option for BLOB data comparison
• Filtering of comparison results
• Schema synchronization script generation
• Per record viewing of data differences
• Exclude tables and records from synchronization
• Save and load comparison settings

Database Project

• New project wizard with import from an existing database
• Project Explorer window for managing project files
• Object View window for browsing logical project structure
• Export of project files into one script
• Reference checking while building
• Multiple build configurations
• Single-click project deployment on the server
• Database object refactoring
• Schema comparison tool integration
• Workspace saving

Customizable User Interface

• Rich user settings
• Customizable window layout
• Tool windows with 'auto-hide' and 'float' modes
• Multiple shortcut schemes with full shortcut customization
• Syntax highlight customization
• Tabbed groups for documents
• Toolbars customization
• Ability to browse schema objects in a single editor (pin document option)
• Wizard for exporting/importing user settings

Order Download