dbForge Studio for MySQL, Express Edition 3.10

dbForge Studio for MySQL, Express Edition 3.10 is designed to help you take full advantage of a powerful development environment for working with MySQL. dbForge Studio for MySQL an easier way to develop SQL scripts and stored routines, create and execute queries, manage users and privileges, explore existing databases, modify schema objects, export and import data, create database projects, and more.

dbForge for MySQL, Express Edition provides basic functionality for working with schema objects, user accounts, and SQL scripts. Express Edition is free. dbForge Studio for MySQL is a standalone application that runs with .NET Framework 1.1 or 2.0. dbForge Studio for MySQL supports all features of MySQL server versions 3.2.3 and higher.

Major Features:

1.  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 unicode databases (UTF-8)
   • Support of SSL/SSH/HTTP connections
   • Work with MySQL embedded server
2. 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
3. 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
4. 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: CSV, DBF, HTML, MS Access, MS Excel,ODBC, PDF, RTF, Text, and XML
5. Database Designer [New]
   
   • 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
6. 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 the diagram
   • Expression builder for creating complex conditions
   • Undo/Redo support
   • Saving queries to a file
7. 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
8. 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
9. 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
10. Data Comparison and Synchronization
    
    • Comparison of large tables
    • Optional view comparison
    • Custom comparison keys support
    • Option for BLOB data comparison
    • Comparison results filtering
    • Schema synchronization script generation
    • Per record viewing of data differences
    • Exclude tables and records from synchronization
    • Save and load comparison settings
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 re-factoring
    • Schema comparison tool integration
    • Workspace saving
12. 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

WareSeeker Editor