dbForge Schema Compare for MySQL Features

MySQL Connectivity

• Support of all MySQL server versions 3.23-5.1
• Comparison and synchronization of databases on different versions of MySQL server
• Support of SSL/SSH/HTTP connections
• Connection Manager for a full control of database connections
• Automatic connection recovery [New]

Database Structure Comparison

• Quick and accurate comparison with Schema Comparison wizard
• Comparison of all major MySQL database objects
• Command line launch for schema comparison and synchronization [New]
• Swap button to swap Target and Source databases on Schema Comparison wizard

Analyzing Structure Differences and Synchronization

• Clear display of schema differences in the grid
• DDL differences in the text comparer with multicolor higlights based on the difference type
• Automatic grouping of objects by their type
• Capability to manage groups of objects in the comparison document
• Convenient filtering of objects by name or difference type
• Sorting of compared objects
• Objects exclusion from synchronization
• Saving and loading of comparison settings
• Schema comparison reports generation [New]
• Synchronization script preview for any separate schema object
• Options to customize the synchronization script output
• Warnings on possible data losses or errors during synchronization
• Asynchronous structure synchronization

SQL Execution and Data Management

• Execution of SQL scripts and queries
• 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) viewer
• Text search in data editor
• Data printing
• Capability to postpone sending of data updates to the server (Cached updates mode)

Clear User Interface

• Customizable window layout
• Tool windows with 'auto-hide' and 'float' modes
• Multiple shortcut schemes with full shortcut customization
• Tabbed groups for documents
• Toolbars customization

Order