dbForge Studio for MySQL 3.50

dbForge Studio for MySQL 3.50 offers an effective tools which functions as a cutting-edge administration tool and development environment for professional working with MySQL databases.

Extended features provide an easier way to quickly explore databases, manage schema objects, setup user accounts and privileges, develop stored routines, and synchronize data between databases. With dbForge Studio you will visually create complex SQL queries, export data with additional settings, format your SQL scripts, create offline projects synchronizing them with a live database and more.

Major Benefits:

1. Visual Database Designer
   • Design the whole database visually with a state-of-the-art visual database design tool - Database Designer.
   • Database Designer allows you to view and edit databases in a convenient visual way. You can observe all objects of the database, see foreign key relations between tables, view database objects information, easily access database objects for editing, retrieving data, executing stored routinesOffline Development with Database Projects
2. Integrated Database Project Development
   • Enhance your work with complex database projects. Instead of doing lots of time-consuming tasks, perfect your management with well-tried features.
   • You can integrate various SQL and script files into a project, group them into folders, and manage in one place. Build your project to a single script file or several ones and easily deploy on the server. Feel differenceStored Routine Debugger
3. Stored Routine Debugger
   • Replace “by hand” debugging with a full-featured debugger tool.
   • Debug stored procedures, functions, and triggers with no worry. You can easily set breakpoints to stop execution on any code line and evaluate variables and parameters declared in routines
   • Schema and Data Comparison and Synchronization Tools
4. Schema and Data Comparison Tools
   • Forget about difficulties, just select two databases (or a database and a project) to compare.
   • Based on your needs, you can compare and synchronize the structures of databases (schema comparison) or the content of databases (data comparison). Manage differences in a convenient window and simply select the required synchronization actions
5. Powerful SQL Management
   • Free yourself from tedious work, while coding, with well-thought features.
   • Speed up your development with code templates, code completion, syntax check, code formatter, and many other options. Make your work simple and pleasantisual Query Builder
6. Visual Query Builder
   • Create effortlessly complex queries which you could not create before.
   • Do not think about coding, just use Query Builder. Drag’n’drop required tables to the diagram, select parameters, set conditions in a convenient editor, and then view and edit a query text.
     
7. Convenient Schema Object Editors
   • Manage efficiently shema objects in visual editors.
   • Get clear and automated ways to work with tables, views, procedures, functions, triggers, events, and user-defined functions (UDF). Take advantage of a quick search and navigation.
8. Centralized Server Administration and Maintenance
   • Have centralized server maintenance with powerful tools.
   • Use Security Manager to have simple and accurate management of users and their privileges. Get total control of user sessions and their information with Session Manager. Benefit from MySQL services empowered with Service Control window. Transform difficult tasks into your new opportunities.
9. Multiformat Data Export
   • Experience visual and accurate data export to well-known formats.
   • You will quickly choose required columns and rows along with additional settings for the selected format. With Data export wizard you can customize and even preview the result. You won’t waste your time changing the exported data, the result will be just what you wanted
10. Intuitive and Highly Customizable UI
    • Tune layout based on your convenience and work on-the-fly.
    • GUI elements are well-located and easy-to-use. Tabbed documents, dockable tool windows, and other customizable elements will give you a quick navigation and full control.

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
   
   • 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 refactoring
    • 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

Enhancements:

1. A new excellent database diagram
   • The new version includes the best visual online database design tool for MySQL - Database Designer. It is indispensable for anyone who needs to build a clear and effective database structure visually and get the complete picture representing all the tables, foreign key relations between them, views, and stored routines of the required database.
   • It streamlines access to the database objects for viewing their properties, editing, retrieving data, and executing stored routines. The database diagram enables reverse engineering of databases to IDEF1X or IE diagrams, which can be easily printed.
   • You can see and use Database Designer in all dbForge Studio's editions. The number of database objects, supported by Database Designer, in the free Express edition is limited to 5 and in the Standard edition is limited to 20. The Professional edition contains the unlimited version of Database Designer.
2. Data comparison improvements
   • While comparing data, dbForge Studio for MySQL 3.50 better caters for the diversity of data comparison tasks. Custom object mapping delivers more freedom in comparison - you can map tables, columns, and views with different names, map columns with different types, or map a table with a view. Always you can cancel custom mapping and return to the automatic one.
   • Mapping process is more simple and clear, now you get detailed information about each mapped column and see warnings, for example, if a comparison key is set incorrectly. You can quickly find the required object for mapping using the Find box or filtering the list of objects by their status (the following are available: valid or invalid mapping, auto or user mapped, fully or partially mapped, included or excluded in comparison).
   • New mapping options Ignore Case, Ignore Spaces, Ignore Undercores are added to let you customize the comparison. Data comparison of any amounts of data has been accelerated and now is 5-10 times faster delivering more customized and understandable comparison results.
3. Schema comparison improvements
   • Schema comparison results management has become more easier and quick due to convenient filtering by object type, update operation, or status, quick search by object name, ability to group by comparison difference type and update operation or cancel grouping at all. You you can grasp the comparison results even quicker thanks to their new representation.
   • The new version offers more speedy synchronization process, moreover adds more visibility and control, as you can preview the synchronization script for any object in the comparison results to ensure the correct synchronization result on the first try.
   • Optimized approach in working with large SQL scripts
   • The new version provides a special Execute Script Wizard to enable quick and convenient execution of large SQL scripts without waiting for their opening in the editor. It takes only to select the script and enjoy the executed result.
4. New additions to free Express edition
   • The free Express edition of dbForge Studio provides more functionality for free. Now it features the limited versions of Query Builder, powerful and visual tool for easy query creation and management, and Database Designer, an advanced tool for visual MySQL database design.
5. Other improvements
   • A number of bux fixes and minor improvements have enhanced the product performance targeting better users' satisfaction.

Requirements:

1. NET Framework 2.0, 3.0, or 3.5 installed
   • To download .NET Framework, click the following architectures to start the download:
   • • X86 Redist Package
     • X64 Redist Package
   • Note, .NET Framework is pre-installed in Microsoft Windows Vista.
2. 2 GHz or higher processor
3. 1024 MB RAM
4. 35 MB of free hard disk space
5. Microsoft Windows 2000/XP/2003/Vista
   

WareSeeker Editor