dbForge Studio for MySQL Express 4.50.316

dbForge Studio for MySQL Express 4.50.316 offers users with an easy to use yet effective and comprehensive MySQL manager and admin IDE. It offers you a complete set of MySQL administration tools, database development, and SQL query tools. Combination of the very best features of existing MySQL front ends and MySQL GUI tools makes dbForge Studio the perfect choice for database developer and administrator.

Now you can manage MySQL databases in a relaxed way. dbForge Studio can save you hours and hours of boring manual work. Have you ever been stuck somewhere in MySQL management? Are you a MySQL administrator that wants to boost productivity? MySQL GUI tools provided by dbForge Studio are here to solve your problems.

Major Features:

1. Visual Query Profiler [New]
   • SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a GUI
   • Plan of the query displayed in the tree view for easy review
   • Profiling history that can be saved for further analysis
   • Capability to compare profiling results in two clicks
   • Capability to print profiling results
   • Visual Query Builder
   • The state-of-art diagram with zooming and keyboard support
   • Preview and printing of the diagram
2. Visual addition of subqueries to any part of the main query [New]
   • 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
3. Server Administration and Maintenance
   • Security Manager to administer user accounts and privileges
   • Quick access to object privileges from Database Explorer
   • Schema Backup and Restore wizards with support of command line
   • interface, removing of old backups and multiple options [New]
   • 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
4. Schema Object Management
   • Quick generating template SQL scripts for database objects [New]
   • 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
5. Data Comparison and Synchronization
   • Comparing and synchronizing data in databases of any size [New]
   • 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
   • Command line launch for data comparison and synchronization
   • Generating accurate comparison reports in HTML and Excel formats [New]
6. Schema Comparison and Synchronization
   • Capability to compare a database with a database
   • Capability to compare a database with a project
   • Schema comparison reports generation
   • Command line launch for schema comparison and synchronization
   • 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
7. SQL Execution and Data Management
   • Execution of scripts, selected SQL fragments, and statements
   • 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: MS Access, CSV, DBF, HTML, MS Excel, 
   • ODBC, PDF, RTF, Text, and XML
   • Data import wizard
   • Customizable data import from MS Access, CSV, DBF, MS Excel, ODBC, Text, and XML
   • formats
   • Composing of data reports
   • Converting data into a pivot table
8. 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 through large scripts
   • Code templates library with a browser window
   • 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 the editor
   • Wizard for batch SQL formatting of files on the disk
   • Dynamic help on MySQL accessible from the editor
9. Database Designer
   • 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
10. 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 session variables when debugging a script
11. 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
    • Project export 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
12. MySQL Connectivity
    • Multiple database connections in Database Explorer window
    • Asynchronous connect to server with cancel feature
    • Support of all MySQL server versions 3.23-5.1
    • Direct access to MySQL server without client libraries
    • Support of UTF-8 databases
    • Support of SSL/SSH/HTTP connections
    • Work with MySQL embedded server
13. 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

Enhancements: