DbForge Studio for MySQL
Encyclopedia
dbForge Studio for MySQL is a software application created by Devart for developing and administrating the popular Relational Database Management System (RDBMS) MySQL
.
Express is a free software, which provides basic functionality for working with schema
objects, user accounts, and SQL scripts.
Standard includes essential tools for database developers, such as a debugger, a Query Builder, code templates, object search, various export and maintenance wizards.
Professional is a full-featured software for database projects, comparing schema and project data, debugging stored procedures and scripts, creating complex queries, etc.
Through 3 years of development the product has raised up to the version 3.0 (released on 01-August-2008), and got a new name - "dbForge Studio for MySQL" as well as a lot of new features and improvements.
Version 4.0 saw release on 10 February 2010. The improved version 4.50 was released on 21 June 2010.
On 19 April 2011 the product version 5.0 was released and is the most current as of now.
Main features of dbForge Studio for MySQL, v5.0 include:
- A comprehensive Security Manager to administer user accounts and privileges;
- Special MySQL administration tools boosting MySQL server maintenance;
- Backup and restore wizards supporting large databases and enabling users to back up and restore schemas or data only in addition to full backups;
- Advanced search tools allowing to find a required database object by any fragment of its CREATE statement, as well as find a data fragment in one or several tables;
- Service control to administrate several MySQL servers on different computers.
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
.
Editions (licenses)
dbForge Studio for MySQL has three editions: Express, Standard, and Professional.Express is a free software, which provides basic functionality for working with schema
Database schema
A database schema of a database system is its structure described in a formal language supported by the database management system and refers to the organization of data to create a blueprint of how a database will be constructed...
objects, user accounts, and SQL scripts.
Standard includes essential tools for database developers, such as a debugger, a Query Builder, code templates, object search, various export and maintenance wizards.
Professional is a full-featured software for database projects, comparing schema and project data, debugging stored procedures and scripts, creating complex queries, etc.
History
The first version was released on 12 April 2005 under the name "MyDeveloper Studio".Through 3 years of development the product has raised up to the version 3.0 (released on 01-August-2008), and got a new name - "dbForge Studio for MySQL" as well as a lot of new features and improvements.
Version 4.0 saw release on 10 February 2010. The improved version 4.50 was released on 21 June 2010.
On 19 April 2011 the product version 5.0 was released and is the most current as of now.
Functionality
dbForge Studio for MySQL has got both standard features of most database tools and unique functionality.Main features of dbForge Studio for MySQL, v5.0 include:
- Administration and Maintenance tools
- A comprehensive Security Manager to administer user accounts and privileges;
- Special MySQL administration tools boosting MySQL server maintenance;
- Backup and restore wizards supporting large databases and enabling users to back up and restore schemas or data only in addition to full backups;
- Advanced search tools allowing to find a required database object by any fragment of its CREATE statement, as well as find a data fragment in one or several tables;
- Service control to administrate several MySQL servers on different computers.
- Query Builder - provides visual creation and management of queries and complex sub-queries in a diagram.
- Query Profiler - a tool for database developers that offers visual query profiling and MySQL query optimization, achieved through comparison of profiling results.
- Reporting and Analysis tools provide extended capabilities to prepare data reports with MySQL reporting tool and conversion of row data to informative pivot tables.
- Multi-format data export to 10 widely-used data formats – CSV, XML, Text, XLS (MS Excel), PDF, DBF, HTML, RTF, MDB (MS Access), ODBC.
- Multi-format data import from 8 widely-used data formats – CSV, XML, Text, XLS (MS Excel), XLSX (MS Excel 2007/2010), DBF, MDB (MS Access), ODBC.
- Database Designer - a visual database design and editing tool for MySQL. Provides the complete picture of all the database objects and their properties, as well as foreign key relations between tables on a MySQL database diagram. Enables easy execution of stored routines.
- Code Debugger – a dedicated debugger for MySQL. Uses database server as an engine for checking user created SQL scripts and automates debugging of stored procedures, functions, and triggers, giving full control over code execution.
- SQL code editor - includes context-sensitive code completion, automatic SQL syntax check and highlighting, SQL formatter wizard, code templates and definitions for schema objects.
- Database synchronization – several synchronization ways provide display of differences, grouping and filtering as well as MySQL schema and data comparison with MySQL sync tools.
- Database projects for MySQL server - include the capability to integrate various SQL and script files into a single project, group them into folders, and manage in one place. You can build your project to a single or several script files and deploy them on the server.
Current version
The latest version of dbForge Studio for MySQL is 5.0. The following features were introduced in this version:- Full compatibility with MySQL server 5.5;
- Master-Detail Browser;
- Object dependency tree;
- Enhanced Data Editor;
- Improved Security Manager;
- Data Export and Import improvements;
- Object Viewer;
- Revised start page;
- New skins.